extract month from date in a query 1

[ch4meleon]

apologies i know this is probably really simple but i cannot get my brain to function at all today !!
I have a query with 2 fields (yep a whole 2)
name
Date
all i want is to convert that to name and the month from the date (currently in dd/mm/yyyy format
please can anyone advise ???
huge thanks in ant

 

[LonnieJohnson]

Month(Date) or

Format(Date,"mmmm") or

Format(Date,"mmm")

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[ch4meleon]

Thank you so much !!

 

[Golom]

But note that

Month(Date)
or
Format(Date,"mmmm")

will probably give you the current date rather than your field of the same name. It's usually recommended that you avoid field names that are also the names of builtin functions or are reserved words (e.g. Date, Now, User, Month, Year, Day, etc.) If you must however then enclose them in square brackets (e.g. [Date]) to indicate that they are field names and not function calls.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]