Works: Performing Summary Calculations in Works Database Report (77606)

The information in this article applies to:

Microsoft Works 2.0
Microsoft Works 2.0a
Microsoft Works 3.0
Microsoft Works 3.0a
Microsoft Works 3.0b
Microsoft Works 4.5
Microsoft Works 4.5a
Microsoft Works for Windows 95, version 4.0
Microsoft Works for Windows 95, version 4.0 4.0a

This article was previously published under Q77606

SUMMARY

To perform calculations in the Database Reporting section of Microsoft Works, insert a formula or an arithmetic calculation in a Summ fieldname row or a Summary row. To add a Summ fieldname row, sort your report and include at least one break. If you insert the calculation in a Summ fieldname row, Works for Windows performs the calculation for a selected group. If you insert the calculation in a Summary row it will perform the calculation for the entire report.

MORE INFORMATION

The following are the valid functions and arithmetic operators that can be used in Works for Windows reports:

Function	Description
SUM	Totals all entries in a numeric field
AVG	Averages all values in a numeric field
COUNT	Counts the numbers of entries in a field
MAX	Finds the largest value in a numeric field
MIN	Finds the smallest value in a numeric field
STD	Calculates the standard deviation of a numeric field
VAR	Calculates the variance for a numeric field
+	Addition
-	Subtraction
*	Multiplication
/	Division
^	Exponentiation

REFERENCES

For more information about how to perform this task in Works for Windows 95, see your Works printed documentation or online Help.

"Microsoft Works for Windows User's Guide," version 3.0, page 425

"Microsoft Works for Windows User's Guide," version 2.0, page 348

Modification Type:	Major	Last Reviewed:	11/15/2004
Keywords:	kbinfo KB77606