2.0
Table Of Contents
Functions
9-30 Using Calculations
Sum
The Sum function returns the total value of a set of numbers and/or
numeric expressions added together.
Usage Example
Sum([num1],[num2], ...)
If the numbers in the fields are 3, 6, and 8
Then the calculation Sum([num1],[num2],[num3]) returns 17
In the example below, test scores are added together and put in the
Total
Scores
field.
Time
The Time function returns the current time based on the current system
clock. The time is returned as HH:MM:SS.
Usage Example
Time()
If a field contains the function Time() and the current time is 18:05:05
Then the value returned is 18:05:05
In the example below, the time is put in the
Form Time
field. (Time
formatting depends on the current field definition.)