asked on MS Access, hourly employee status
I have punch in and out time field.
I would like to create how many employee deploy every hour between 7am to 9pm.
I would like to create how many employee deploy every hour between 7am to 9pm.
Microsoft Access
Last Comment
Hiroyuki Tamura
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I have following table.
![Snap2060.png]()
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you, PatHartman,
Data is like this;
![Snap2061.png]()
I want to create following table;
![Snap2062.png]()
Data is like this;
I want to create following table;
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I'm trying to set 7am flag but somehow not working.
![Snap2065.png]()
red part setting flag on <7
![Snap2066.png]()
red part setting flag on <7 
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you!