Getting Grand Total with Nested Reports

[whdyck]

I am using MS Access 2003.

I have a report in which the highest-level detail band contains a nested Access subreport, inside which is a numeric field in the detail band of the subreport. I would like to generate totals of all of these numeric values through the entire report, to be reported in the report footer.

I have been able to get the total of the values for each highest-level record, using the following formulas:

In the Detail band of the subreport subRptClaimParties:
TotalDemurrageAmount=Sum([DemurrageAmount])

In the hightest-level Detail band:
txtTotalDem=subRptClaimParties.Report!TotalDemurrageAmount

However, now I can't seem to sum all the txtTotalDem values over all highest level records.

Is this even possible?

Thanks for any help you can give.

Wayne

 

[vbaInet]

You can if you write code in the Detail section to sum it up.