Putting months in order (1 Viewer)

[vmorgan]

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]

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")