2.0

Functions
9-20 Using Calculations
Max (Maximum)
The Max function returns the maximum (highest) value of a set of
numbers and/or numeric expressions.
Usage Example
Max([num1],[num2] ...)
If the numbers in the fields are 150, 200, and 45
Then the calculation Max([num1],[num2],[num3]) returns 200
In the example below, the
Top Sales
field displays the highest sales made.
Middle
The Middle function returns the characters from a given string
beginning at a specified starting position from the left in the string, and
continuing to the right for the specified number of characters. The first
(beginning) position in the string is 1.
Usage Example
Middle([str1],start position number,number of characters)
If the field [str1] = 2/14/96
Then the calculation Middle([str1],3,2) returns 14
In the example below, the
Middle
and several other functions extract the
last name from the
Full Name
field and place it in the
Last Name
field.
Refer to these other functions elsewhere in this section for more
information.