Knowledge Base

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

Article ID: 134419

Article Last Modified on 1/19/2007


APPLIES TO


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.

Additional query words: 2.00 3.00 4.00 4.00a 4.50 w_works works2k works6

Keywords: kbhowto kbui KB134419