Sorting by Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have sales data separated by month; however, Access is
sorting the months in alphabetical order rather than
chronological order. How do I fix it?
 
I have sales data separated by month; however, Access is
sorting the months in alphabetical order rather than
chronological order. How do I fix it?
Click to expand...

How is the month actually stored? You should be storing either an
actual date (in a date/time field) or a month *number* (1 to 12). If
you have stored your sales dates/months this way and you are still
getting things sorted by the month name (alphabetical), then your query
must be converting the month number to a month name first, and then
sorting. This is not what you want to do. Please give the details of
the underlying table design and the SQL of the query you are using to
sort it.
 
Back
Top