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 |