If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting Months
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 |
#2
|
|||
|
|||
Sorting Months
On Fri, 27 Feb 2009 05:42:01 -0800, alfiajamel wrote:
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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Sorting Months
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 "Rick Brandt" wrote: On Fri, 27 Feb 2009 05:42:01 -0800, alfiajamel wrote: 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. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|