Counting to get total on report

J

joe

Hello,

I have ten employees that i am tracking the hours
worked.Is it possible to have a calculated field which
would count the number of employees on report and then
multiply that by 40(40 hour work week)for instance, 10
employees x 40 =400 total hrs?
Thanks
 
J

Jeff Boyce

Joe

Yes.

Add an unbound field. Set it's Control Source to an expression (formula)
that does the calculation you need. You will need to have the "number of
employees" field/value available as part of the report.
 
Top