U.M. (Windows)

Creating a database file 2-23
Defining summary fields
Important The value in a summary field depends on the layout part in
which you place the summary field, so you must know about parts and
summary parts to get the results you want. Before you define a summary
field, see “Working with layout parts” on page 3-24 and “About
summary layout parts” on page 3-29.
1. Create a new file, or choose Define from the File menu and then
choose Fields.
2. In the Define Fields dialog box, for Field Name, type a name for the field.
3. For Type, select Summary, and then click Create.
4. In the Options for Summary Field dialog box, select the type of
summary to perform, and then select the name of the field that
contains the values to summarize.
5. If you want, select a summary option, if applicable to the summary type.
To summarize values in a field
in the found set of records by Select
Calculating the total of values in the field Total of
Calculating the average of values in the field Average of
Counting the number of records that contain a value for the field Count of
Finding the lowest number, or the earliest date or time, for a field Minimum
Finding the highest number, or the latest date or time, for a field Maximum
Calculating the standard deviation from the mean of the values in
a field. (The formula is n-1 weighted, following the normal
standard deviation. For population standard deviation, see step 5.)
Standard Deviation 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 individual sales person.)
Fraction of Total of
For this
summary type To Select
Total of Show the cumulative total for the
current and all previous records
Running total
Average of Determine the average in one field
based on a value in another field
that’s used as a weight factor
Weighted average. In the list
of fields that appears, select
a field name for the
averaged values.