Summing two report totals on form

[BrockWade]

Not sure this can be done, but here goes... I have a form with two reports displayed simultaneously... I need the total of each to appear in a textbox... I tried the below:

([Reports]![rptBookDepositTotal]![AccessTotalsAmount])+([Reports]![rptPrevUnRecTotal]![AccessTotalsAmount])

Maybe I should merge the two driving queries (?):



SELECT PreviousUnRec.Store, PreviousUnRec.Amount
FROM PreviousUnRec
ORDER BY PreviousUnRec.Store, PreviousUnRec.Amount DESC;

SELECT Book.Store, Book.Amount, Book.Date
FROM Book
ORDER BY Book.Store, Book.Amount DESC;

[AlexHedley]

Did you add that to the control source of the unbound textbox?
Was there an equals (=) sign at the start?

[rpeare]

you're talking about referencing subreports on a main report you'll need the right syntax:

Reports![main report name]![subreport control name].Report![control name]

see this article:

http://support.microsoft.com/kb/209099

[BrockWade]

I may be close... the fully qualified naming of the textbox's control source is
=([Form]![Book Bank and Unmatched]![qrySumBookDeposit]![SumField])+([Form]![Book Bank and Unmatched]![qrySumPrevMon]![SumField])
with the form being "Book Bank and Unmatched" and one report being "qrySumBookDeposit" and the other being "qrySumPrevMon" with a report field called "SumField" in both

[rpeare]

are your subreports just datasheet views of queries (the qrySumBookDeposit makes me think so) or is the subreport actually a report named qrySumBookDeposit?

you want the qrySumBookDeposit and qrySumPrevMon to actually be the NAMES of your subreports as they appear on your main report, not the source object.

[BrockWade]

qrySumBookDeposit and qrySumPrevMon are the actual names of the subreports... should I be referencing the "Child" name like Child47, Child49, etc.?

[rpeare]

The names of the subreports (as objects) may be different than the names of the objects on your report, look at the NAME field of the two subreports

Here's an example

BrockWade.zip