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

Report / Subreport sum

P: n/a
Hello all,
I'm using Access 2000. I have a subreport control which loads a
report in the detail section of a main report. I need to keep a count
of each item price in the subreport and place it in the Report footer
of the main report. Each post i've read on this seems to not work
and/or give me the same problems the other posters are having: a box
coming up asking for parameter values. Thanks in advance for your
help.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I found my answer - the site I referenced was
http://www.mcse.ms/message867397.html

No other page I found made any mention to the RunningSum property, but
that must have been it. To clarify, here is what did the trick:

Subreport has a non-visible text box in the Report Footer, say it's
called txtTotal, with a control source of =Sum([Price]) (where price
is the field to keep a sum of - the field from the query, not the
control name).

Main report has a non-visible text box in same section as where the
subreport control is. In my case it is the Details section. This
text box, say it's called txtSumOfSubreport, has a control source of
=IIf([subReportControlName].Report.HasData,[subReportControlName].Report.txtTotal,0)

where subReportControlName is the name of your subreport control and
txtTotal was the name of the non-visible text box from the subreport.
You also need to set this text box, txtSumOfSubreport to have a
RunningSum property of Over Group.

Next, in the Report Footer of the main report, you need a text box
that is visible with a control source of =[txtSumOfSubreport], or in
my case, =Format([txtSumOfSubreport],"Currency").

All that did the trick. Thanks to anyone who looked over this post,
and I hope this will clarify for anybody else who is stuck like I was.
la********@hotmail.com (last Name) wrote in message news:<ec************************@posting.google.co m>...
Hello all,
I'm using Access 2000. I have a subreport control which loads a
report in the detail section of a main report. I need to keep a count
of each item price in the subreport and place it in the Report footer
of the main report. Each post i've read on this seems to not work
and/or give me the same problems the other posters are having: a box
coming up asking for parameter values. Thanks in advance for your
help.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.