Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-02-12
4
Medium Priority
?
2,667 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 51

Accepted Solution

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

=Format([DateWorked],"yyyymm")

/gustav
0
 
LVL 51

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 51

Expert Comment

by:Gustav Brock
ID: 39853196
You are welcome!

/gustav
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

719 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