I have an MSAccess 2007 DB to record our employees Personal Days Off (PDO). Until now I have only had a form to record each single day taken. This results in time consuming repetitive entry when an employee takes multiple consecutive days or weeks off.
My database consists of two tables:
- tbl_PDO (to hold the Worker, DateTakenOff and TimeTaken)
- tbl_Employees (containing the Employees