Apple AppleWorks 5 : Mac OS - Manual (Page 194)

8-12 AppleWorks 5 User’s Manual
You enter a formula for a calculation or summary field just as you do for a
spreadsheet cell. (See “Working with formulas” on page 7-21.) The type of
operation a formula performs depends on the field type of the values it
calculates and whether the formula’s field type is calculation or summary.
1
Use a calculation field to calculate a value from values in other fields in
the current record.
1
Use a summary field to calculate a summary value using values from one
or more records in the database.
You immediately see the result for a calculation field in Browse mode and
List mode when you add records, and when you change values used in a
calculation.
Note To see the result for a summary field, you must create a summary part
in Layout mode, and insert the summary field. Then, sort the records and
switch to page view. For more information about summarizing data, see
“Presenting and summarizing data with parts” on page 8-36.
Adding, changing, and deleting fields
You add, change, and delete database fields in the Define Fields dialog box.
To select a field name, click the name in the Field Name list.
* Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
To Choose Define Fields from the Layout menu, and then
Add a field Type the name of the new field, choose a type from the
Field Type pop-up menu, and then click Create
Delete a field Click the field name in the Field Name list, and then click Delete
Change a field name Click the field name in the Field Name list, type a name, and
then click Modify
Change a field type Click the field name in the Field Name list, choose a type from
the Field Type pop-up menu, and then click Modify
Change a calculation or
summary formula Click the field name in the Field Name list, click Modify, make
your changes to the formula, and then click OK
Change field entry options Click the field name in the Field Name list, click Options, make
your changes in the dialog box, and then click OK
In the Help index, * see:
E
Define Fields command