User manual

Defining database fields | 89
If you’re modifying a layout that contains a summary field, you must know
about layout parts to get the results you want (see
“Working with parts on a
layout” on page 128).
1. With the database open, choose File menu > Manage > Database.
In Layout mode, click Manage in the status toolbar, then choose
Datatabase.
2. In the Manage Database dialog box, click the Fields tab.
3. If your file contains more than one table, select the appropriate table from
the Table list.
4. For the Field Name box, type a name for the field.
See “About naming fields” on page 81.
5. For Type, select Summary, then click Create.
6. In the Options for Summary Field dialog box, select a summary type, then
select the name of the field you want to group by.
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.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 89 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ