Putting months in order

vmorgan

New member
Local time
Today, 02:03
Joined
Jan 19, 2000
Messages
5
I have a report that pulls information up by the month. I want the information to sort January through December. As it is now it starts with April, August ect...Any suggestions?
 
When you sort months use their numeric value not the text value. You can add a field to your query with this as a value
Month([MONTHFIELD] & " 1")
 

Users who are viewing this thread

Back
Top Bottom