Sum of sums in report

[kirnavi]

Can anyone tell me how to sum sums in a report?

I have my report data, and I end up with three sums on my report. They are calculated in the report footer. Then I have to add all three but I can't get Access to reference the earlier sums.

Furthermore, I have to create another report that is identical to this one but for another department. Then I have to create a third report which will add up the first two reports.

Thanks in advance for any help.

 

[dhookom]

You should be able to sum the values of three text boxes as long as they are all in the same section.
=txtSum1+txtSum2+txtSum3
or
=Sum([Field1]) + Sum(Field2) + Sum(field3)
or
=Sum(Field1+Field2+Field3)
You may have issues if any values are null. This can be fixed in the expressions using Nz(Fieldx,0).


Duane
MS Access MVP
Find out how to get great answers faq219-2884.