sorting data by months in access 2000

N

Neptun

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.
 
P

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
 
Top