beautypg.com

Defining calculation and summary fields – Apple AppleWorks 5 : Mac OS User Manual

Page 193

background image

Database

8-11

For complete information on every field type available in AppleWorks, see
onscreen Help.

Defining calculation and summary fields

You define a field type as a calculation or summary field when you want the
value in the field to be the result of a formula. A formula can include values
from one or more other fields in the database, operators, functions, and
constant values.

For example, suppose you have a database that contains two number fields,
Qty Sold and Price, and one calculation field, Total. You can set up a formula
in the calculation field to multiply the values in the two number fields. Then,
each time you type values in the Qty Sold and Price fields, the formula
multiplies those values and displays the result in the Total field.

*

Choose Index from the

or Help menu and scroll to the entry. Then choose a topic from

the list and click Go To Topic.

In the Help index,

*

see:

E

formulas, database

Click field names, operators, and functions
to include in the formula

Choose a format for

the formula result

Name of field that
holds the formula