Sum Textboxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T Horner - 06 Jan 2006 15:59 GMT

I have a report that has several textboxes in the report footer section.
These are all calulated textboxes. I would like to Average groups of them to
create a summary. I need errorchecking as at times the textboxes will read
#NUM!. Where should I put the new summary textboxes and how should I enter
the control source? I appreciate your help.

Tyra

Reply to this Message

Duane Hookom - 06 Jan 2006 16:53 GMT

You can't sum controls. You can sum values or expressions from the fields in
your report's record source.

Signature

Duane Hookom
MS Access MVP
--

>I have a report that has several textboxes in the report footer section.
> These are all calulated textboxes. I would like to Average groups of them
[quoted text clipped - 4 lines]
>
> Tyra

Reply to this Message