Select query depending on two criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 27 May 2005 21:51 GMT

I have a query that I want to select records based on two sets of criteria.
I want to select if the ship date is less than two years OR there is a qty on
hand. How would the query be setup? Thanks for your assistance.

Reply to this Message

Rick B - 28 May 2005 02:21 GMT

Randy:

You would put the criteria for one field on the first row in the criteria
section in the query builder window.

Then, put the criteria for the second column on the next row inthe criteria
section.

Placing criteria on separate rows creates an OR condition. Putting criteria
on the same row creates an AND condition.

Rick B

> I have a query that I want to select records based on two sets of criteria.
> I want to select if the ship date is less than two years OR there is a qty on
> hand. How would the query be setup? Thanks for your assistance.

Reply to this Message