User manual

Creating a database 5-7
4. In the Options for Summary Field dialog box, select a summary
type, then select the name of the field you want to group by.
5. Select an option, if applicable, for the summary type.
Options change according to the summary type you select in the
previous step.
6. Click OK.
7. Continue defining fields, or click Done.
For more information about summary fields, choose Help menu >
Contents and Index, click the Index tab, and type summary fields.
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 or time,
for a field
Maximum Finding the highest number, or the latest date or time, 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, this option
finds what fraction of total sales can be attributed to each
salesperson.
Choose a
summary
type
Choose the
field you want
to group by
Select an option for the summary type
For this
summary type Select To
Total of Running total Show the cumulative
total for the current and
all previous records
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
Standard Deviation of by population Calculate population
standard deviation, where
the formula is n-weighted
Fraction of Total of Subtotaled. In the list of
fields that appears, select a
field to group by. (When
you return to Browse mode,
sort by this field to calculate
the value correctly.)
Calculate a fraction of the
total based only on a
group of records