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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarieK - 16 Mar 2007 19:09 GMT

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.

Reply to this Message

Jerry Whittle - 16 Mar 2007 19:52 GMT

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

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> 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
[quoted text clipped - 6 lines]
>
> Any suggestions!??!?! Thanks in Advance.

Reply to this Message

Jerry Whittle - 16 Mar 2007 19:53 GMT

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

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Reply to this Message