Sort by Month

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have the following expression in a column of a query.
FinalShipMonth: (Format([FinalPlantShipDate],"mmm")).

The months are sorting alphabetically, even when I click
Ascending. I'm assuming because my expression isn't
reading date field any longer.

Is there a way I can rewrite this formula so I can sort by
month; jan, feb, mar, etc...

Thanks for your help,
Alex
 
Alex,

To sort by the numeric value of the month, add a column to your query:

FinalShipMonth_Sort: Month([FinalPlantShipDate])

and, sort on that column.

hth,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting a MONTH field in a cross-tab Query correctly 8
Excel Help with dates 2
Sorting Month-Year in Query 7
Crosstab By Date (Month) 5
Crosstab query date field sorted by day instead of month 1
Sorted and Unique Date Period 2
Keeping 12 months of records 6
access crosstab queries month range 2

Back
Top