By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,706 Members | 1,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,706 IT Pros & Developers. It's quick & easy.

Show Total In Subreport On Main Report

P: n/a
How do you display a total from a subreport on the main report. If it makes
a difference, the total is a total of a calculated field (Qty * Price). Does
the total on the subreport go in the pagefooter or report footer? Say the
total is shown in a texrbox named MyTotal and the subreport control is named
MySubreportControl, what exactly do I put in the control source of a textbox
on the main report to show the total?

Thanks For All Help!

Marie
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Marie,
Your total control in the subreport should be in the report footer. You can
reference it in your main report with syntax like:
=MySubReportControl.Report!MyTotal
If you expect that the subreport may not return records, you can use:
=IIf(MySubReportControl.Report.HasData, MySubReportControl.Report!MyTotal,
0)

Congrats on asking a clear question. It's nice getting some good information
on your needs and conditions.

--
Duane Hookom
MS Access MVP
--

"Marie" <pl****@no.spam> wrote in message
news:X3****************@newsread3.news.pas.earthli nk.net...
How do you display a total from a subreport on the main report. If it
makes
a difference, the total is a total of a calculated field (Qty * Price).
Does
the total on the subreport go in the pagefooter or report footer? Say the
total is shown in a texrbox named MyTotal and the subreport control is
named
MySubreportControl, what exactly do I put in the control source of a
textbox
on the main report to show the total?

Thanks For All Help!

Marie

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.