I am using MS ACCESS 2000 and am having great difficulties with a date field and would greatly appreciate any help:

SELECT Bulletins.Last_Status_Date, Bulletins.Status
FROM Bulletins;

This will return a date field like the one below:

Last_Status_Date

12/23/2002
12/13/2002
12/23/2002
11/3/2002
11/2/2002
10/4/2002
9/6/2002
8/7/2002
7/21/2002
6/23/2002

My question is: Is there any way to display the month that these dates come under instead of the full date...Like so
Decemeber
December
December
November
October
''
''
''

Regards pat

yes, format(Last_Status_Date,"mmmm")


rudy
http://r937.com/

Thanks Rudy,
I shall try this.