two sets of parameters..one query...but how?

M

MarieK

I have a query to track when I must renew State Police Clearances AND Child
Abuse Clearances. I want to use the "Between [date] and [date]" function on
BOTH of the fields in order to bring up BOTH sets of dates for BOTH
clearances.

The problem I am running into is that when the query results come up, if one
date doesn't meet the criteria NONE of the information comes up (even if the
other date DOES).

Any suggestions!??!?! Thanks in Advance.
 
J

Jerry Whittle

Put the criteria on two different rows. That makes it an OR statement where
either or both matches will return the record.
 
J

Jerry Whittle

Put the criteria on two different rows. That makes it an OR statement where
either or both matches will return the record.
 
Top