How to combine report totals and subreport totals?

[Apollo6]

I have a main report with grand totals in the report footer. I also have a subreport in the report footer that has grand totals itself.

What I want to be able to do is combine both grand totals to give complete grand totals for the report as a whole. After building the text box formula, my result displays "#Name?" on the report footer. Any suggestions are appreciated.

Main Report Name>>> rptDrug_Financials
Sub Report Name>>> rptDrug_Financials_Deliveries


Main Report-[txtTotal_Gross_Charge]>>> =Sum([GROSS CHARGE])
SubReport-[txtDel_Ttl_Charges]>>> =Sum([units]*[cpt_charge])

Combined Totals>>> =[txtTotal_Gross_Charge]+[Reports]![rptDrug_Financials_Deliveries]![txtDel_Ttl_Charges]

 

[jebry]

Hi!

Access won't recognize the names of calculated controls. You need to repeat the calculations.

Combined Total =Sum([GROSS CHARGE]) + Sum([units]*[cpt_charge])

For the second sum you may need to do a DSum on the domain instead.

hth


Jeff Bridgham
bridgham@purdue.edu