sorting data by months in access 2000

[Guest]

I am trying to sort data in a query which contains the months of the year. I
am only able to sort it alphabetically and not by the monthly sequence.

 

[MacDermott]

Are your months entered as text, or as dates?

 

[Guest]

The format is Date/Time.
Thx

Are your months entered as text, or as dates?

 

[Perry]

Try to adjust below sql code to yr situation in a query

(note: i've used simple aliases)

SELECT MyTable.MyDateField, Year([Mydatefield]) AS a,
Month([mydatefield]) AS b,
Day([mydatefield]) AS c
FROM MyTable
ORDER BY Year([Mydatefield]), Month([mydatefield]), Day([mydatefield]);

Krgrds,
Perry