name footer totals in report footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rong - 08 Jan 2006 18:37 GMT

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

Reply to this Message

Duane Hookom - 09 Jan 2006 14:56 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 4 lines]
> Thanks,
> Ron

Reply to this Message

rong - 09 Jan 2006 15:33 GMT

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

Reply to this Message

Duane Hookom - 09 Jan 2006 15:45 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

> 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

Reply to this Message