Select query depending on two criteria

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

Guest

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