Queries V: Use And, Or, and In to set multiple conditions

Use And and Or in your queries

Learn how to use conditions with the "And", "Or", and "In" operators in queries. These operators can help you find data that matches multiple conditions, such as all your French customers who own their businesses.

Start course button

About this course

This course includes:

  • One practice session for hands-on experience. The practice requires Access 2007.

  • A Quick Reference Card you can take away from the course.


After completing this course you will be able to:

  • Use complex criteria in queries.

  • Work with the And, Or, and In operators.

Before you begin

Topics in this course

  1. Set multiple conditions in a query

  2. Set multiple conditions for a single field

  3. Specify the same condition for different fields

  4. The difference between "And" and "Or"

  5. Use the "In" operator

  6. Practice

  7. Quick reference card

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language