Not sure if you received my question of a couple of days ago.  I asked about getting a query/report to group/sort by week, but the week has to start on Thursday.  I have used the DatePart ( interval, date, [firstdayofweek], [firstweekofyear]) and the Weekday ( date_value, [firstdayofweek] ) functions - but when I group by Week: Format([Date],"ww")and then use the functions above - it puts the dates in the incorrect weeks and then sorts starting on Thursday - so I get something like this:  Week: 39
Date Schedule # Hours
Thursday, September 26, 2013 1 5:00 am - 1:00 pm 8.00
Friday, September 27, 2013 2 5:00 am - 1:00 pm 8.00
Monday, September 23, 2013 5 5:00 am - 1:00 pm 8.00
Tuesday, September 24, 2013 6 5:00 am - 1:00 pm 8.00
Wednesday, September 25, 2013 7 5:00 am - 1:00 pm 8.00

Can anyone help me on this?