MSAccess Query Select Distinct Date

[Walt]

Need to extract the distinct monthName.
The closest I could get is

SELECT DISTINCT (Format(appointmentdate,'mmmm')) AS distinctmonth

which of course does not work. Please advise.

[r937]

i'm sorry, but that does work, i just tested it

any chance you could explain how it doesn't work for you?

was there an error message? did it return anything? did it return something other than month names?

what is the datatytpe of your appointmentdate column?