name footer totals in report footer

[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

 

[Duane Hookom]

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.

 

[rong]

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

 

[Duane Hookom]

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.