Sorting Months

[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

 

[Rick Brandt]

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

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.

 

[Patricia]

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