MSAccess query. Extract distinct month name.

[contiw]

Need to extract distinct month name from date column.
I have found something like this
-----
SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth
-----
which does not work.
Please advise. Thank You.

 

[scriverb]

Try using the DatePart function in your query.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[PHV]

SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth
Works for me (access2003), as this:
SELECT DISTINCT MonthName(Month(appointmentdate)) AS distinctmonth

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244