If you add multiple lines of criteria to a query, the row returned in the results must be true for all the specified criteria.

 

If you want to return rows that meet one criterion or another, you use Boolean logic, such as:

• AND

• AND NOT

• OR

• OR NOT

 

In this topic, you will review multiple criteria.


Table of Contents