name footer totals in report footer

  • Thread starter Thread starter rong
  • Start date Start date
R

rong

I thought I already posted this but I don't see it.
I have a control in my name footer for each page of a report that I
need to sum for the report footer page. The control is
=IIf(([peas])>0,[text32]+[ptotal]+[stotal],[text32]). I can't figure
out how to sum this control.
Any idea would be appreciated.
Thanks,
Ron
 
You can't sum controls. You can sum expressions created from fields in your
report's record source.

I don't know which section you mean when you state "report footer page".
This is the last page of the report unless I don't understand.
 
The report footer is on a separate page and I want to add the totals
for each page. If I replace each of the [text??] controls with the
actual expression would that work?

Thanks,
Ron
 
You haven't told us anything about your [text??] controls. If their control
sources are something like:
=Qty*UnitPrice
then summing would work for:
=Sum(Qty*UnitPrice)

I'm not sure what a " name footer for each page of a report " is. There are
group footers and a page footer. I would think that summing values from page
footers would be near impossible. Summing values from your report's
recordsource are generally quite easy.
 
Back
Top