Sorting Months

[Deb]

I have a date (DateOfApp) which I have formated as "mmmm"
in a aggregate query for a fiscal summary report (MS
Access 2000). Everything works great, grouping by fiscal
year and month; however, the months sort alphabetically
instead of by calendar order. I have checked all the
usual places and have no sort order set anywhere that I
can see. Is there an easy way to get the months to sort by
calendar order? Am afraid I don't know much VB, but could
do entries in Design View or SQL.

Thanks much!

 

[Douglas J. Steele]

Add a computed field that returns the month number (either the Month
function, or format as mm, not m). Sort on that field, even if you don't
show it on the report.