Extract Month & Year from a date

[vranjit138]

i have a field named Date-Datatype is Date and each row contains data 8/2/2007 8:02:00 AM

Now in another column i need to extract only the month&year . How can i have records only showing month&year . I need a append query . Please help

 

[schielrn]

Can you just use a formula in the column?

Month: Month(Date)
Year: Year(Date)

Its been a while since I have used access, but I believe that is possible.

 

[Joe4]

You can use the Format function in a calculated field, i.e.

MyMonthDate: FORMAT([DateField],"mmyyyy")