Sum Total in Text box of Report gives #Error

  • Thread starter Thread starter Benny via AccessMonster.com
  • Start date Start date
B

Benny via AccessMonster.com

I have a report with a text field named Amount. In the controlsource property
of the Amount field, I have =([CountOfDept ID])*50 which takes the number of
deptid’s times 50 . This is working fine, But now I need to total all the
amounts.

Now in the page footer, I want to total the amounts using =Sum([Amount]) in
the controlsource field on the page footer, but I get #Error.

Can any help me out with this??

Thanks,
Benny
 
You can't Sum() controls and aggregates don't work in page footers and
headers. You should be able to use a text box in a group or report header or
footer with a control source of:
=Sum([CountOfDept ID])*50
This assumes CountOfDept ID is a numeric field in your report's record
source.
 
Thank You Duane!! Putting it in the report footer works fine....

Duane said:
You can't Sum() controls and aggregates don't work in page footers and
headers. You should be able to use a text box in a group or report header or
footer with a control source of:
=Sum([CountOfDept ID])*50
This assumes CountOfDept ID is a numeric field in your report's record
source.
I have a report with a text field named Amount. In the controlsource
property
Click to expand...
[quoted text clipped - 11 lines]
Thanks,
Benny
Click to expand...
Click to expand...
 
Back
Top