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.
 
Back
Top