Apple M9057 User Manual - Page 194
Adding, changing, and deleting fields, in Layout mode, and insert the summary field. Then
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 194 highlights
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. In the Help index,* see: E Define Fields command 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 Click the field name in the Field Name list, click Modify, make summary formula 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 * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.