Extrapolating month and year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
In the field, put:

Month: Month([your field name])

In the criteria put:

Month(Now())

Do the same for year
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting parameter to date field formatted xx/xx/xxxx 1
Date Range 1
question about running a certain query in access 2
Long Date - Can't pull records accurately 3
Calculating Age from Birthdate field in Query 4
Query a text field 1
Multiple Expiration Dates Query 1
Crosstab not showing null values/fields 5

Back
Top