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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group Totals in Report 7
Excel VBA - counting cells by colors and names to it in two different rows. 0
Labour Report Help 1
percentages calculated for a report 1
IIf statement in a report 2
Counting how many records have writing in two columns. 1
Help with grouping and sorting 5
Strange equation behavior 1

Back
Top