Totaling fields in Sub & Main Report

[Pammyd]

I have a main report that adds my field "amount" and a sub-report that adds it's "amount" field. I want a TOTAL AMOUNT of the two fields combined at the end of the report. I've tried using the expression builder to do a "sum" but no luck. Help?

 

[CosmoKramer]

Try just adding the two fields together. Add a text box with the control source something like this:

=[MainTotal] + [SubTotal]

 

[Pammyd]

Please be more specific for me. I am so new at this. My field names are "Amount." I opened a text box and dumped in what you said but I think there's something more I need to do. Obviously my field names didn't match you're suggestion. Please help again.

Thanks!
Pam

 

[CosmoKramer]

Add a text box to your report footer. In its control source, put the following, changing to your report names:

=[Amount]+[Your Report subreport].[Report]![Amount]

This should add your Amount field from your main report to the Amount field from your subreport......

 

[Pammyd]

That resulted in the image window reading out
#Name?

And when I try to preview it it gives me a pop-up window that asks for Parameter value for one of my report names. If I enter it I still get the #Name? when it previews.

My main report and sub report read off a query.

Any ideas what I'm doing wrong?

Thanks in again for your help.

 

[darkstarjk]

Try using the build function in the ControlSource box for your bound textbox. If you open that up go to Loaded Reports, Go all the way into your report and find the first field that you want to add and double click it, then for the sub report you go down one farther, and find the value, then double click it.

It sounds like something isn't acurately spelled right.