Sorting Days in a report (1 Viewer)

[ootanbon]

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?

 

[peldridg]

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