ControlSource Field Not Calculating Correctly

[Benny via AccessMonster.com]

I have a query that counts the number of dept-ids. I’m using this query in a
report. How can I multiply the count field by $50?

On the control source field, I’m using: =Sum([CountOfDept ID]*50) but
it’s giving me the wrong results. For instance if the count is “1” the
amount should be 50 but it’s showing 1500.

Thanks,
Benny

 

[Al Camp]

Benny,
Is...
=Sum([CountOfDept ID])
always correct, and do you have that placed in a group or report footer?
Then try...
=Sum([CountOfDept ID]) * 50
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions