User manual

Chapter 3 | Creating databases 64
3. In the Options for Summary Field dialog box, select a summary type, then select the name of
the field you want to group by.
4. Select an option, if applicable, for the summary type.
Options change according to the summary type you select in the previous step.
Select this type of
summary To summarize values in a field in the found set of records by
Total of Calculating the total of values in the field
Average of Calculating the average of values in the field
Count of Counting the number of records that contain a value for the field. For example, if a
field contains 100 values (one value for each record), the result of the count is 100.
Minimum Finding the lowest number, or the earliest date, time, or timestamp for a field
Maximum Finding the highest number, or the latest date, time, or timestamp for a field
Standard Deviation of Finding how widely the values in a field differ from each other. This option
calculates the standard deviation from the mean of the values in a field. (The
formula is n-1 weighted, following the normal standard deviation.)
Fraction of Total of Calculating the ratio of the value in the field to the total of all the values in that field.
For example, find what fraction of total sales can be attributed to each salesperson.
For this summary type Select To
Total of Running total Show the cumulative total for the current and
all previous records. To restart the running
total for each sorted group, also select
Restart summary for each sorted group.
Then, from the fields list, select the field that
the sort will be restarted from.
Average of Weighted average. In the list of
fields that appears, select the field
that contains the weight factor
Determine the average in one field based on a
value in another field that’s used as a weight
factor
Count of Running count Show the cumulative count of the current and
all previous records. To restart the running
count for each sorted group, also select
Restart summary for each sorted group.
Then, from the fields list, select the field that
the sort will be restarted from.
Choose a
summary type
Choose the field
you want to
group by
Select an option
for the summary
type
Select an option for summarizing repetitionsRestart the
total or count