• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3186
  • Last Modified:

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:

=Format([DateWorked],"mmmm")

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?

--Steve
0
SteveL13
Asked:
SteveL13
  • 3
1 Solution
 
Gustav BrockCIOCommented:
Use this:

=Format([DateWorked],"yyyymm")

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

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

/gustav
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now