Click to See Complete Forum and Search --> : MSAccess query. Extract distinct monthName


contiw
June 4th, 2004, 10:00 PM
Need to extract distict monthNames from date column.
This
------
SELECT DISTINCT (Format(appointmentdate,'mmmm')) AS distinctmonth
------
does not work. Please advise. ThankYou.

hspc
June 5th, 2004, 06:54 AM
SELECT distinct Month(appointmentdate) AS distinctmonth
from MyTable