User Guide

Special operators Definition
AS Both conditions must be met.
, Create this field name (provided by the user
following the AS operator) and add to Answer
table.
! Requests that all values be displayed, regardless of
match; Specifies the table from which all records
are to be used in a joined table query.
Reserved words Definition
CALC Requests that the result be displayed in a new
calculated field in the Answer table.
CHANGETO A global editing tool used to change matching
values.
INSERT Inserts a specified value into records.
DELETE Deletes records with specified values.
SET Defines a record set of matching values for set
comparisons.
Summary operators Definition
CALC AVERAGE Calculates the average of the values.
CALC COUNT Displays the total number of matching values.
CALC MAX Displays the highest value for the field.
CALC MIN Displays the lowest value for the field.
CALC SUM Provides the total of the values for the field.
CALC ALL Calculates a summary based on all the values in a
group, including duplicates.
CALC UNIQUE Calculates a summary based on all the unique
values in a group.
Set comparison operators Definition
ONLY Display only those values matching values in a
defined set.
NO Display only those values that do not match any
values in the defined set.
EVERY Display only values that match every value in a
defined set.
382 Paradox 10