MSAccess query. Extract Distinct monthNames

[contiw]

I have found this
SELECT DISTINCT Format(appointmentdate,'mmmm') AS distinctmonth
but it does not work.
Please advise. ThankYou

[rachel2004]

Where is the name of your table in your SELECT query?

I don't use Access daily, but shouldn't your statement read something like:

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

Or is "distinctmonth" the name of the table? In which case, I would advise dropping the AS word.

[contiw]

Thanks Raquel. I did find the solution.
The SQL statement works ok as it is.
The problem is that mine was a ColdFusion "query of query"
a new gizmo that still has some limitation.
On a "normal" query everithing works as expected.
Thanks again. Have a nice weekend.

[rachel2004]

Hmm, interesting... you're using ColdFusion, but posting at a PHP forum, haha. ;-)

Anyway, you have a good weekend too. And it's Rachel, not Raquel. ;-)