Use AND and OR Operators in a Query

How to Use AND and OR Operators in a Query in Access

Use AND and OR Operators in a Query

An AND operator always allows a query to match two or more conditions, such as which people are business owners and live in France.

An OR operator allows a query to match only one of several conditions, such as what people live in France or in Mexico.

In this lesson, you'll learn how to add AND and OR operators to a query.

  1. Display the query in Design view.
    Create a Query
  2. Enter your criteria in the appropriate field's first Criteria box.
  3. Enter additional criteria as follows:
    • AND: Enter additional criteria for one or more fields in the appropriate field's Criteria box. All AND criteria should appear on the same row.
    • OR: Enter additional criteria for one or more fields in the appropriate field's or box, using a different row for each OR criteria.
  4. Save and run the query.
    Create a Query

FREE Quick Reference

Click to Download