Get months to sort by correct order, not alphabetically 1

[Mack2]

In my report, it is grouped by months. How do I get it to group in the order of Jan, Feb, March etc. instead of alphabetically (April ...)
Thanks!!!

 

[PHV]

Why not grouping and sorting by Month number instead of Month name ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Mack2]

That worked. I do not know why I did not think of that. Thanks!