Examples of expressions that use logical operators

Microsoft Query

Examples of expressions that use logical operators

Logical operators compare two values.

Logical
operator


Meaning


Example
In the Criteria Field, click In the
Value box,
type
And This value and another value within the same field must be true for records in the result set. Finds records for orders placed within a certain range of dates Order_Date >6/5/2000 And <6/23/2000
Or This criterion or another criterion must be true for records in the result set. Finds records for suppliers in either of two locations Country USA Or Brazil
Not This criterion must not be true for records in the result set. Finds records for suppliers not located in a specific country Country Not Canada