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