Using Boolean Operators
The And operator allows you to specify two or more criteria for selection.
The Or operator lets you specify two or more criteria, and your selected records must meet at least one of the criteria.
The Not operator eliminates certain records meeting a criteria from the query results.