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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, PatHartman,
Data is like this;
I want to create following table;
Data is like this;
I want to create following table;
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm trying to set 7am flag but somehow not working.
red part setting flag on <7
red part setting flag on <7
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!
ASKER