Criteria for qry to show all records for a certain month

  • Thread starter Thread starter Angela M
  • Start date Start date
A

Angela M

I need to do six monthly reviews and therefore need the
criteria for my query to show all applicants who applied
in Jan and July, Feb and August, etc of each year. How do
I write the formula that will set the criteria for this
query?
 
In your query, type an expression like this into the Field row:
(Month([ApplicationDate]) - 1) Mod 6

Then in the Criteria row, enter 0 if you want Jan and July, 1 for Feb and
August, etc.

The Month() function takes the month of the date.
The Mod operator divides the result (less one) by six to give 6-monthly
intervals.
 

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

Parameter in Qry 2
How to get all records in a Query even you select a record from a conbox box 2
Access Dcount (multiple criteria) 3
Null Month records for a field 2
Training schedule -need qry to return all employees for that month 1
query prompt for One or ALL months in database 4
Setting a Month Criteria 9
Extracting Month and Year For a Given Date 3

Back
Top