467,075 Members | 900 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,075 developers. It's quick & easy.

Show Total In Subreport On Main Report

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
  • viewed: 4252
Share:
1 Reply
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.

Similar topics

6 posts views Thread by Steve Jorgensen | last post: by
5 posts views Thread by Robert | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.