Operators
Using Calculations #
Usage Conventions
Substitute the appropriate field name where you see
num
and
str
in the
function examples. Parentheses are required where indicated. Below is
a list of conventions showing operator and function usage.
Operators
Operators represent mathematical, comparison, logical, and text
operations to be performed within a calculation. You must have an
operator between fields in a calculation.
For example, a calculation for a
To ta l
field
might look like this:
[Price1] + [Price2] + [Price3]
The plus signs between the field names are the
Addition
operators in the
calculation.
The calculation could also look like this:
Sum([Price1],[Price2],[Price3])
The parentheses are the operators in the calculation. Commas, although
not operators, also separate the fields.
Operator Function
date
date value: the expression must evaluate to a valid date
time
time value: the expression must evaluate to a valid time
num
number or numeric expression; num1, num2, and so forth indicate
additional number values
str
text string: str1, str2, and so forth indicate additional string values
...
additional repeating values of the given type may be entered
[ ]
brackets inserted around field names
log exp
logical expression
true exp
true expression
false exp
false expression
To Next Page
Loading...