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 txtSumOfSubrepo rt, has a control source of
=IIf([subReportContro lName].Report.HasData ,[subReportContro lName].Report.txtTota l,0)
where subReportContro lName 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, txtSumOfSubrepo rt 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 =[txtSumOfSubrepo rt], or in
my case, =Format([txtSumOfSubrepo rt],"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********@hotm ail.com (last Name) wrote in message news:<ec******* *************** **@posting.goog le.com>...
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.
