Results 1 to 2 of 2
Jun 4, 2004, 17:22 #1
- Join Date
- Apr 2004
- Fountain Valley, California
- 0 Post(s)
- 0 Thread(s)
MSAccess Query Select Distinct Date
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.