Microsoft KB Archive/134419

= 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


 * Microsoft Works 6.0
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition

-



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+sum+sum+sum

where,  ,  , and   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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.