Grand total

N

nellteww

I am trying to set up a grand total of totals.
Total is [unit1]+[unit2]
and the grand total at the end of the report is of the form
Sum([unit1]+[unit2])
All I get on the report is #error
what am I doing wrong?
 
B

Beetle

Where are you putting the calculated control for Grand Total?

It needs to go in the Report footer. It will not work in the Page footer.
 
N

nellteww

Thank you. That did the trick - things take so long to work out for a beginner!

Beetle said:
Where are you putting the calculated control for Grand Total?

It needs to go in the Report footer. It will not work in the Page footer.
--
_________

Sean Bailey


nellteww said:
I am trying to set up a grand total of totals.
Total is [unit1]+[unit2]
and the grand total at the end of the report is of the form
Sum([unit1]+[unit2])
All I get on the report is #error
what am I doing wrong?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group Totals and Grand Totals on each page 3
Grand Total for a calculated column - Access 2007 1
One and One-half Columns and Grand Total on Same Page (?) 5
Dumb question alert! What program to use? 0
Report Grand Total Miscalculating Overtime 5
Don't know how to build report 0
Protecting against a null value in a calculated field 4
Filter on Grand Total 2

Top