Access Logical Operators
This page lists the logical (or Boolean) operators in Access.
The values bool1 and
bool2 in the examples
are variables or expressions with the value True or False.
Refer to Access Help for details of their behaviour when either
or both arguments are Null.
Note that these operators can also process numeric values. They
do this by considering each bit in the binary number as a boolean
value where 1=True and 0=False.
| <bool1> And <bool2> |
The And operator returns True if both <bool1> and
<bool2> are true.
|
| <bool1> Eqv <bool2> |
The Equivalence operator returns True if <bool1>
and <bool2> have the same value.
|
| <bool1> Imp <bool2> |
The Implication operator returns False if <bool1>
is True and <bool2> is false. Otherwise it returns
True.
|
| Not (<bool1>) |
The Not operator returns True if <bool1> is False. It
returns False if <bool1> is True. If
<bool1> is a numeric value the Not will return a number
where each bit of <bool1> has been inverted.
|
| <bool1> Or <bool2> |
The Or operator returns True if either one of <bool1> or
<bool2> are True or if both of them are True. Do not confuse
this with the Xor operator described below.
|
| <bool1> Xor <bool2> |
The Exclusive Or operator returns True if either one of <bool1>
or <bool2> are True but not if both of them are True or if both
of them are False.
|
Other functions
Access Date and time functions
Access numeric functions
Access text functions
|
Alvechurch Data are based close to Birmingham and provide Microsoft Access and Visual FoxPro training, development and support.
Read More
|
Your Access database will look more impressive if you add custom toolbars.
Read More
|
Alvechurch Data specialise in Microsoft Access and Visual FoxPro databases and have fifteen years experience developing databases for small business use.
Read More
|
Microsoft Access and Visual FoxPro training courses and workshops offered by Alvechurch Data in Birmingham.
Read More
|
How Alvechurch Data can help you with maintenance and support of your Access and FoxPro databases.
Read More
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
