Interactive Tutorial
How to Use AND and OR Operators in a Query in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
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.