ControlSource Field Not Calculating Correctly

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

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
 
Back
Top