Viewing 7 posts - 1 through 8 (of 8 total)
Very creative!
I wish I would have thought of that....anyway it will do the job...thanks again!
May 17, 2011 at 1:59 pm
I am not sure if this will help, but here is some data from the result of my query...it is not all but it gives a good idea:
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary12011-1220110101/01/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-1220110101/02/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-1220110101/03/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-1220110101/04/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-1220110101/05/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-1220110101/06/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-1220110101/07/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-1220110101/08/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary32011-1220110101/09/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary32011-1220110101/10/2011
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary32011-1220110101/11/2011
...and here is...
May 17, 2011 at 1:24 pm
Below is the beginning of the result set of the query joined to the date dimension table..
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary12011-12201101
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-12201101
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-12201101
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-12201101
NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLJanuary22011-12201101
Below is a conitnuation of the result set from the query
Beginning of YearBeg2011-129/5/201151LNF010RedKenjiaSampsontest2September22011-12201109
Beginning of...
May 17, 2011 at 12:18 pm
I am new to this forum....how can I display some data or screenshots for you?
May 17, 2011 at 12:12 pm
Yes...even when I do what you suggested it is still not sorting. Again ..it is showing the months exactly as seen in the query of the data set....
So let...
May 17, 2011 at 11:57 am
I completely understand the logic in the sorting....which leads me to believe that it could be in my query..
Below is my query that I am using to build the data...
May 17, 2011 at 11:40 am
I allready have a Year prompt for the school year (i.e. 2011-12) and so that gives me a result set of months Jan - Dec....but what I need to do...
May 17, 2011 at 11:06 am
Viewing 7 posts - 1 through 8 (of 8 total)