Sorting Dates in Queries

  • Thread starter Thread starter tbd
  • Start date Start date
T

tbd

I have a query where I have formatted a date field to
display the information as mmm/yyyy. However, when I try
to sort this data, it groups all April together and so
forth. The problem here is that the data is spread over
the past four years, and I want to sort the data date
sequentially, i.e Jan 01 followed by Feb 01 etc. How can
I do this,

Thanks in advance for any help!
 
Use an extra field in your query just for the sorting, without displaying
it. The field should be the date field again, formatted as "yyyy/mm";
sorting on it will give you the right sorting.

HTH,
Nikos
 
You should refer to the date column in the ORDER BY clause
without any reformating e.g.

SELECT Format(dateCol, "mmm/yyyyy") etc
FROM etc
ORDER BY dateCol

Hope This Helps
Gerald Stanley MCSD
 

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

Back
Top