V vmorgan New member Local time Today, 02:03 Joined Jan 19, 2000 Messages 5 Jan 20, 2000 #1 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?
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?
Travis Registered User. Local time Yesterday, 18:03 Joined Dec 17, 1999 Messages 1,332 Jan 20, 2000 #2 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")
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")