Microsoft Office Tutorials and References
In Depth Information
Writing Decision-Making Expressions
Built-In Comparison Operators
Is equal to
Is greater than
Greater than or equal to
Is greater than or equal to
Is less than
Less than or equal to
Is less than or equal to
Not equal to
Is not equal to
Is within the range of
Is one of a list of values
Is similar to (for string expressions)
You can use the Access built-in logical operators to combine several
comparisons into a single expression that results in a True or False value. Table
2-8 lists the logical operators.
Built-In Logical Operators
Both conditions are True .
One condition is True , or both conditions are True .
Exclusive “or” — one condition is True , but both
conditions aren’t True .
The condition is not True .
Both expressions are True , or both expressions are
This operator performs a bitwise comparison of
identically positioned bits in two numeric expressions. Refer to
Access help for assistance with the Imp operator.
Take a look at the following example IIf() function, which uses the And
IIf([Last Name]=”Pines” And [First Name]=”Tori”,”No Charge”,”Charge”)