Summing totals from 2 subreports

[Bob 4]

I have an invoice report called rptInvoice with two subreports: srptCosts and
srptPayments. Each subreport lists the transactions and sums them in the
footer: txtTotalCosts and txtTotalPayments. I'd like to calculate and show
the balance on the main report but I'm having problems with the syntax.

What is the proper syntax to select the value from a textbox from the footer
of a subreport from the main report?

Much appreciated. bob

 

[Duane Hookom]

I would create two totals queries that sum the costs and payments by
invoices. Include these in the record source of your main report and join the
invoice fields. You will then have your numbers in the report. You may need
to use a LEFT or RIGHT JOIN to the payments query since you might not have
received any payments on an invoice.