[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
SUM
SUM totals expressions involving numeric fields in the active database
file.
Syntax
SUM [<scope>] <expN list> TO <memvar list> [FOR <condition>]
[WHILE <condition>]
Argument
<expN list> is the list of numeric values to SUM for each record
processed.
<memvar list> identifies the receiving memory variables for the SUM and
are created at the time of execution of the command. Existing memory
variables with the same names are overwritten. This list must contain
the same number of elements as the list of expressions to SUM.
Option
Scope: The <scope> is the portion of the current database file to
SUM. The default scope is ALL.
Condition: The FOR clause specifies the conditional set of records
to SUM within the given scope. The WHILE clause specifies the set of
records meeting the condition from the current record until the
condition fails.
See Also:
AVERAGE
TOTAL
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson