How make report sort by month name in logical order, not alphabetically

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?

Who is Participating?
Gustav BrockConnect With a Mentor CIOCommented:
Use this:


Gustav BrockCIOCommented:
And your original expression for the visible textbox.

SteveL13Author Commented:
Thanks as always.
Gustav BrockCIOCommented:
You are welcome!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.