Sorting Days in a report

  • Thread starter Thread starter ootanbon
  • Start date Start date
O

ootanbon

Guest
I'm basing a report on a query in which the order of the days is important (Monday, Tuesday, Wednesday.. instead of Friday, Monday,Tuesday,Thursday,Wednesday). In the query, I'm able to order the days using a Switch(Day="Monday",1,Day="Tuesday",2..) statement, but the report reverts to the bad alphabetical ordering that I DON'T want. How can I get it so that days are ordered in the report as they do in the query?
 
How is the Day data stored in the table? You need to store the day as a number in the table as 1=Mon, 2=Tues, 3=Wed etc instead of converting it when you run the report.

Hope this helps.
Phil
 

Users who are viewing this thread

Back
Top Bottom