Adding the values from 2 text boxes on different reports

[Jessica240]

Hello! Does anyone know if it is possible to add the values from two different text boxes from two different reports? I have one main report that has a subreport in it. I need the total from the main report added to the total from the subreport to give me one grand total at the bottom.

The main report and the subreport do not share the same control source - they get their data from 2 different queries. I don't have a way to link the queries so I'm not sure how to get around this.

Any advice would be greatly appreciated! Thanks in advance!

Jessica

[June7]

In the subreport footer have textbox with the sum for the records on the subreport, named like tbxSubTotal.

Then in the main report footer have a textbox that references the subreport textbox as well as sum the main report records, something like:

=Sum([fieldname]) + [subreport container control name].Report.tbxSubTotal