Pulling totals from sub-reports to main reports

[jaaret]

I have a text box named txtRevCreditAmt on a main form that is pulling sub-report totals into the detail of each order:

=rsubOrderCredit.Report!txtTotalCreditAmt

Is there a way to create a sum of this value at the end of the main report? =Sum(txtRevCreditAmt) obviously doesn't work. Is there some other way to capture the grand total?

Jaaret

 

[dhookom]

You can try duplicating the current text box and set a running sum. Then add a text box in the report footer with a control source of the running sum text box name.

You should also be able to create a totals query similar to your subreport query and add it to the record source of your main report. Then you can simply total this column.

Duane
Hook'D on Access
MS Access MVP

 

[jaaret]

Ah - great use of the Running Sum feature. That did the trick. Thanks!

Jaaret