Totals from SubReport in Main Report

G

Guest

HI,

I have three subreports on a report, but I would like the totals from two of
the subreports to be totalled into one final total on the main report. But I
can't seem to get anywhere with this I keep getting error messages, any
suggestions?

Thanks!
 
G

Guest

Use this as the source of the text box on the main report

=[SubreportName1] . Report ! [ControlName] + [SubreportName2] . Report !
[ControlName]

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subreport On No Data 1
Header Problem (page header & report header) 2
Report asks for Parameter and Won't Display Subreport 7
Subreport problem 2
Help! i cant get Nz function to work in report! 1
report with multiple subreport question 6
subreport totals on Main report 3
Access How to prevent subReport from breaking across pages? 1

Top