Microsoft Office Tutorials and References
In Depth Information
Writing Decision-Making Expressions
Table 2-7
Built-In Comparison Operators
Comparison
Operator
Name
Meaning
Equals
Is equal to
=
>
Greater than
Is greater than
>=
Greater than or equal to
Is greater than or equal to
<
Less than
Is less than
<=
Less than or equal to
Is less than or equal to
<>
Not equal to
Is not equal to
Between
Is within the range of
Between
In
Is one of a list of values
In
Like
Is similar to (for string expressions)
Like
Combining comparisons
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.
Book III
Chapter 2
Table 2-8
Built-In Logical Operators
Logical Operator
Meaning
Both conditions are True .
And
Or
One condition is True , or both conditions are True .
Xor
Exclusive “or” — one condition is True , but both
conditions aren’t True .
Not
The condition is not True .
Eqv
Both expressions are True , or both expressions are
False .
Imp
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
operator:
IIf([Last Name]=”Pines” And [First Name]=”Tori”,”No Charge”,”Charge”)
Search JabSto ::

Custom Search