Hiroyuki Tamura

asked on

# Calculate Number of Employees Who Were At Work Each Hour?

Calculate Number of Employees Who Were At Work Each Hour on MS Access?

I am trying to come up with a set of formulas to calculate how many employees were on the clock fo each hour of the day based on:

https://www.mrexcel.com/forum/excel-questions/614617-calculate-number-employees-who-were-work-each-hour.html

The link provide the solution for MS Excel but I would like to build with MS Access.

I am trying to come up with a set of formulas to calculate how many employees were on the clock fo each hour of the day based on:

https://www.mrexcel.com/forum/excel-questions/614617-calculate-number-employees-who-were-work-each-hour.html

The link provide the solution for MS Excel but I would like to build with MS Access.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thank you!

I'll try and let you now.

I'll try and let you now.

ASKER

Works great!

Glad you were able to understand the directions. This isn't a trivial task.

Show the required output.