Report / Subreport sum

[last Name]

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.

[last Name]

Re: Report / Subreport sum

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.


lastname_5@hotm ail.com (last Name) wrote in message news:<ec3aee.04 08060550.22d6f7 a0@posting.goog le.com>...[color=blue]
> 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.[/color]