If the date/time field is named Date1, you could type an expression like
this into the Field row in query design:
Format([Date1], "mmmm-yyyy")
That will generate text which doesn't sort correctly, e.g. April before
January, and not by year. So a better solution might be to just set the
Format property of the field (in the Properties box in query design.) Use:
mmmm-yyyy
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Reply to group, rather than allenbrowne at mvps dot org.
Silvio said:
I have a date field that stores date and time. How can I extract in a query
only the month and year (e.g. March-1992 or 3-1992 - I am not concerned
with
the date format)
Thank you,
Silvio