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.

SELECT * FROM employee
WHERE NOT (fname = 'Ann')
					

SELECT * FROM employee
WHERE lname = 'Smith' AND fname = 'Ann'
					

SELECT * FROM employee
WHERE region = 'UK' OR region = 'FRA'