Sum of field

A

andrena

Trying to total a field on a report. example:

_Field_
$44
$58
$21
Total:

I know this must be easy. I know I can do it in the report or the Quer
(this report is done from a Query). Access help recommended I do thi
operation in a query. In the query the field I'm trying to total i
called Expr1. Help with a report or query calculation would be muc
appreciated.

Thanks in Advanc
 
D

Duane Hookom

Add a text box to a group or report header or footer and set the control
source to
=Sum(_Field_)
 
D

Duane Hookom

You should not have trouble Sum()ing a numeric column from a column in a
query. It might help to know the expression of the calculation.

Also, make sure the control is in one of the sections that I mentioned
earlier and NOT the page header or page footer.
 
Top