Sorting Days in a report (1 Viewer)

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?
 

peldridg

Registered User.
Local time
Today, 13:58
Joined
Oct 23, 1999
Messages
13
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 (Users: 0, Guests: 1)

Top Bottom