Logical operators (ADP)

Microsoft Office Access 2003

previous page next page

Logical operators (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

You can combine or modify search conditions using the standard logical operators listed in the following table. The operators are listed in the order that they are evaluated.

Operator Meaning Example
NOT Logical opposite of condition 
SELECT * FROM employee
WHERE NOT (fname = 'Ann')
AND Both conditions must apply 
SELECT * FROM employee
WHERE lname = 'Smith' AND fname = 'Ann'
OR Either condition can apply 
SELECT * FROM employee
WHERE region = 'UK' OR region = 'FRA'
previous page start next page