Works: How to Add the Totals of Several Fields into One Grand Total

This article describes how to add the totals of several fields into one grand total in a report in Microsoft Works Database.

To calculate a sum of the totals in a database report, type the following formula on a Summary row where field1, field2, field3, and field4 are the names of the fields that you want to include in the grand total.

Works can calculate the total of a single field automatically if you select Sum in the Report Statistics dialog of the report generator. However, if you want to add the totals of several fields into one grand total, you must use the above formula.