Grand Total of several reports on one

G

Guest

Hello,

I have several different reports that all have a sum on them. I need to sum
all of those totals on one master total report. Any suggestions.

On a second note: When I have tried to put them all on one report and one of
the elemenets returns a no value the answer in the grand total report returns
an error.

Thanks JC
 
M

Marshall Barton

Joe said:
I have several different reports that all have a sum on them. I need to sum
all of those totals on one master total report. Any suggestions.

On a second note: When I have tried to put them all on one report and one of
the elemenets returns a no value the answer in the grand total report returns
an error.
Click to expand...


The main report text box would use an expression like:

=IIf(subrpt1.Report.HasData, subrpt1.Report.sumtextbox, 0) +
IIf(subrpt2.Report.HasData, subrpt2.Report.sumtextbox, 0) +
.. . .
 

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

Grand total 2
Grand Total for a calculated column - Access 2007 1
Filter on Grand Total 2
Can't calculate Grand Total of several other expressions 1
Group Totals and Grand Totals on each page 3
Grand total 14
Grand totals in reports 6
Help With Grand Total for Subreports 16

Top