Extrapolating month and year

[scubadiver]

There seems to be not a great deal that can't be done with Access.

Can this be done in a query using the short date xx/xx/xxxx?

thanks

 

[scubadiver]

In the field, put:

Month: Month([your field name])

In the criteria put:

Month(Now())

Do the same for year