Databases Reference
In-Depth Information
If rs Is Nothing
It is also sometimes used as a return value for some functions, generally to indicate that
some operation has failed. Finally, it is used to initialize object variables.
10.5 VBA Operators
VBA uses a handful of simple operators and relations, the most common of which are
shown in Table 10-5.
Table 10
-
5. VBA operators and relations
Type
Name
Symbol
A
rithmetic operators
Addition
+
Subtraction
-
Multiplication
*
Division
/
Division with Integer result
\
Exponentiation
^
Modulo
Mod
S
tring operator
C
oncatenation
&
L
ogical operators
AND
A
ND
OR
OR
NOT
N
OT
C
omparison relations
Equal
=
Less than
<
Greater than
>
Less than or equal to
<=
Greater than or equal to
>
=
Not equal to
<
>
The
Mod
operator returns the remainder after division. For example:
8 Mod 3
returns 2, since the remainder after dividing 8 by 3 is 2.
To illustrate string concatenation, the expression:
"To be or " & "not to be"
is equivalent to:
"To be or not to be"
