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


The information in this article applies to:

  • Microsoft Works 6
  • Microsoft Works 2000
  • Microsoft Works 2.0
  • Microsoft Works 3.0
  • Microsoft Works 4.0
  • Microsoft Works 4.5
This article was previously published under Q134419

SUMMARY

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

MORE INFORMATION

To calculate a sum of the totals in a database report, type the following formula on a Summary row

=sum(field1)+sum(field2)+sum(field3)+sum(field4)

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.
Modification Type:MajorLast Reviewed:11/24/2003
Keywords:kbhowto kbui KB134419
©2003 Microsoft Corporation. All rights reserved.