Result of page total is #ERROR ?

[Lulu]

Hello,
Can anyone tell me what I did wrong here?
I have a text box named [amount] in the Detail Section. I
have another text box [pgTotal] in the page footer
section. [pgTotal] control source is set to =Sum([amount]).
I keep getting #ERROR result.
Please help!
Thanks.

 

[Rick Brandt]

Hello,
Can anyone tell me what I did wrong here?
I have a text box named [amount] in the Detail Section. I
have another text box [pgTotal] in the page footer
section. [pgTotal] control source is set to =Sum([amount]).
I keep getting #ERROR result.
Please help!

Aggregate functions like Sum(), Min(), etc., do not work in Page
Header/Footers. Only in Report Header/Footers and Group Header/Footers.

 

[Gary Miller]

Also, in addition to Rick's comments, if you are going to
Sum() on a control from your Group or Form footer, make sure
that the control has a name that is different from it's
underlying datasource or you will throw another error. If
your datafield is 'Amount', change the name of the control
that holds it to 'txtAmount' or something of that nature.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________