How make report sort by month name in logical order, not alphabetically
Posted on 2014-02-12
I have a report that has two groupings. Group by FullName (which is employee name), and then by Date Worked. But date worked is formatted like:
in the control source. By doing this it prints, for example, "January" if the date worked was 1/13/2014.
But then because it is grouped by Date Worked (which is therefore alphabetical), the months don't appear in calendar order. They appear alphabetically which isn't what we want.
How can I make the results print in calendar order?