Summing a value in a report with a value in a subreport

[Guest]

Hi,

I have a report that is grouped by a field called Type. There are two
values in type which are Existing Customers and New Customers. There is a
"Type" header that has each value and a "Type Footer" that has the sum of
each category. There is then the Grand Total which sums these two and is in
the Report footer. I have a subreport that also appears in the report
footer. It is also grouped by Type with existing and new customers and a
Grand Total. I need to keep them separate because they query different
things. I want to be able to sum the Existing Customers total from the main
report to the Existing Customers totals from the subreport. I then want to
sum the New customers totals from the main report to the existing customers
total on the sub report and then I want to sum both Grand Totals. Can anyone
help?

Chuck

 

[Allen Browne]

First you need to get the subreport total back onto the main report. See:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

You can then add the two text boxes by setting the Control Source of another
one to:
=[Text0] + [Text2]
That won't work if either is null, so you probably want to use:
=Nz([Text0],0) + Nz([Text2],0)