Counting to get total on report

  • Thread starter Thread starter joe
  • Start date Start date
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
 
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.
 
Back
Top