Sum Total in Text box of Report gives #Error

[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

 

[Duane Hookom]

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.

 

[Benny via AccessMonster.com]

Thank You Duane!! Putting it in the report footer works fine....

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

[quoted text clipped - 11 lines]

Thanks,
Benny