Microsoft KB Archive/32387

Works: Summing a Field or Record in the Database

PSS ID Number: Q32387 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

The Microsoft Works for MS-DOS SUM function is designed to store the sum of different fields in a field of its own. For example, if field 1 contains last year’s tax and field 2 contains this year’s tax, then field 3 may contain the SUM function (that is, SUM[FIELD1, FIELD2]), which stores the total tax for both years.

You cannot use the SUM function to sum the values in a given field and store that sum in a later record of the same field. However, this process can be done by defining a new report using the reporting feature of the Works database. From the List screen, use the Report, New command to create a new report. This report screen contains formulas that sum the values in a given field.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.