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

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

Guest

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.
 
Put the criteria on two different rows. That makes it an OR statement where
either or both matches will return the record.
 
Put the criteria on two different rows. That makes it an OR statement where
either or both matches will return the record.
 

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

Why is my report not bringing all info over from my query? 2
union query 2
Date search query 0
How do I get rid of multiples on my report? 2
Using Date parameters in select queries Access 2003 5
Parameter Query 2
Access Invalid bracketing of parameter name 1
Problem with date criteria in Query 2

Back
Top