Total Text Box in Report Page Header?

[monkeysee]

I have a report with a sub-report to make up an invoice.
The main report has the accumulated balance owed from previous billings greater than 30 days in a text box (#27) , and the subreport reveals new billings less than 30 days old. The subreport also has a text box (#10) that shows the total owed from previous balance plus the new billings.

What I want to do, is to also have a text bx in the page header that shows the total currently owed.

The formula in the subreport which shows the total owed from both reports is:
=Sum([FeeAmount]+[Reports]![AerationInvBalanceFwd]![Text27])

If I make another text box for the main report header and paste that formula in the control I get a: #Name? error.

Name of the main report is: AerationBalanceFwd
the sub report name is: SubRptAerationBilling

So, is what I want to do even possible in ACCESS reports, and if it is, what am I doing wrong?


Thanks for all your help!!!

 

[dhookom]

Is the "formula in the subreport which shows the total owed from both reports" working? Subreports don't have page sections.

Your subject line suggests "Report Page Header" but your question states "Report Page Header". Which is it? Typically bound controls in report page headers don't work as expected. Report headers are preferred.

You mention #10 and #27 but I don't see control names that match both. I you meant Text10 and Text27, just say so or maybe change their names to something that makes sense.

Duane
Hook'D on Access
MS Access MVP

 

[monkeysee]

Duane,
Thank you for your quick response!

Yes! the formula is working in the subreport.

I want to place a new text box in the page header of the main report.

the text box (text10) in the subreport contains the total owed from previous balance plus the new billings.

The text box (text27) in main report has the accumulated balance owed from previous billings greater than 30 days.

 

[dhookom]

I'm not an accountant so I don't understand "accumulated balance owed from previous billings" without you providing field names, control sources, and control names.

Duane
Hook'D on Access
MS Access MVP