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?