Result of page total is #ERROR ?

  • Thread starter Thread starter Lulu
  • Start date Start date
L

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.
 
Lulu said:
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!
Click to expand...

Aggregate functions like Sum(), Min(), etc., do not work in Page
Header/Footers. Only in Report Header/Footers and Group Header/Footers.
 
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
________________________
 
Back
Top