Criteria for qry to show all records for a certain month

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?
 
A

Allen Browne

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