User manual

Chapter 2
|
Creating databases 49
7. Select an option, if applicable, for the summary type.
Options change according to the summary type you select in the
previous step.
8. Select an option, if applicable, for summarizing a repeating field.
9. Click OK.
10. Continue to define fields, or click OK.
For more information about defining fields, see Help.
Setting options for fields
You can set field options when you define a field, or at a later time.
You can set options for:
1 entering default data into a field
1 checking data against validation requirements
1 making a repeating field
1 creating an index
1 storing a global value
1 Furigana fields (Japanese language fields only)
Some field options help ensure the accuracy and consistency of your
data. For example, if you type
Frnc instead of France into the Country
field, you won’t find that record when you later search for all
customers from France. To be sure that all country names are entered
correctly, you can define a value list containing the names, then select
the
Member of value list validation option for the Country field. When
you enter data into the field, the data must match a value in the list.
For more information on value lists, see “Setting up checkbox sets and
other controls on a layout” on page 62.
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.
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
Select To
All together Calculate a single summary value for all repetitions in the
field
Individually Calculate a summary value for each repetition