Solved

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

Posted on 2014-02-12
4
2,468 Views
Last Modified: 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:

=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
Comment
Question by:SteveL13
  • 3
4 Comments
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39853170
Use this:

=Format([DateWorked],"yyyymm")

/gustav
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39853173
And your original expression for the visible textbox.

/gustav
0
 

Author Closing Comment

by:SteveL13
ID: 39853187
Thanks as always.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39853196
You are welcome!

/gustav
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question