Summing Sum totals

[Jamescdawson]

I have a report in which I have grouped and summed weights from many records. The summed total weight for that group is in a text box with the control =Sum([PaperWeight]) I also have a second calculation for =Sum([cardboardWeight]) I also have these two sums added together with... =Nz([TotalsPaperWeight])+Nz([TotalsCardboardWeight]). This all works well...



I now want to calculate a grand total of all the group sum totals and for it to appear at the bottom of the report, but I can't it right. I've tried a number suggestions detailed in earlier posts on the forum, but I get #Error no what changes and sysntax I use. I'm guessing it's something real simple, but I can't get it. Is it something to do with Text Box verses Combo box for the calculation ?

I've looked at similar problems in the forum and tried some options without success.

Any suggestions?

[June7]

Did you try in Report Footer: Sum(Nz([CardboardWeight]) + Nz([PaperWeight]))

[Jamescdawson]

June7

Yes, that worked... Thanks

For clarity..... Did it work because it was put into the report footer? I was previously trying to do the calc in the page footer.

[June7]

Yes, that could make a difference. Did you try that exact expression in page footer?

Also, can't use calculated textboxes in aggregate expressions, must be fields of RecordSource.