Microsoft Access 2010 Bible

Chapter 5: Using Operators and Expressions in Access

183

TABLE 5.3

Or Expression Results

Expression1 Expression2 Expression1 Or Expression2

True True True

True False True

True Null True

False True True

False False False

False Null Null

Null True True

Null False Null

Null Null Null

The Not operator

The Not operator negates a numeric or Boolean expression. The Not operator returns the True if

the expression is False, and False if the expression is True. The general syntax of Not is

Not [numeric|boolean] expression

The following examples show how to use the Not operator:

Not [Price] <= 100000 Returns True if Price is greater than

100,000.

If Not (City = “Seattle”) Then Returns True for any city that is not Seattle.

If the operand is Null, the Not operator returns Null. Table 5.4 shows all the possible values.

TABLE 5.4

Not Operator Results

Expression Not Expression

True False

False True

Null Null