Sorting Months

  • Thread starter Thread starter alfiajamel
  • Start date Start date
A

alfiajamel

Greetings Everyone,

I am trying to sort months in a report. Of course you know that Access
sorts alphabetically. How do I get it to sort correctly. I have added
numbers 1-12 in the mean time to get it to sort correctly, however, it looks
tacky. Please help!

Thanks,
AJ
 
Greetings Everyone,

I am trying to sort months in a report. Of course you know that Access
sorts alphabetically. How do I get it to sort correctly. I have added
numbers 1-12 in the mean time to get it to sort correctly, however, it
looks tacky. Please help!

Thanks,
AJ
Click to expand...

Well, Access sorts *text* alphabetically. If you want chronological
sorting then you need to use actual dates, not just months.

You can sort by a field that you do not display so "looking tacky" should
not be a problem. Just include both a numeric month and the month
names. Sort on one and display the other.
 
My company fiscal year is from Oct-Sep, so I created a separate table listing
the months in order by Oct-Sep and then a sort order column 1-12. I link
this table through a query so that my data will sort in the order I want not
alphabetically. Hope this helps.

Sample
Sort Order Month
1 Oct
2 Nov
3 Dec
 
Back
Top