Calculating totals on a report

  • Thread starter Thread starter greenbg via AccessMonster.com
  • Start date Start date
G

greenbg via AccessMonster.com

Hi
I have a report that I get a total in several field. See below example of the
fields:

Field-1
$123.00
$ 0.00
$234.00
---------------
$357.00

I have tried the following:
=[field-1]+[field-1]
=sum([field-1])

bg
 
Hi
I have a report that I get a total in several field. See below example of the
fields:

Field-1
$123.00
$ 0.00
$234.00
---------------
$357.00

I have tried the following:
=[field-1]+[field-1]
=sum([field-1])

bg
Click to expand...

Sum([field-1]) will work... but the textbox with that as the control source
must be in the Report Footer, or a section footer if you want subtotals on a
grouped report. It cannot be in the detail section nor in the Page footer.

John W. Vinson [MVP]
 
Back
Top