Tracking Employee Availability
You should be able to store availability in a table like;
tblEmpAvail
============
eavEAvID autonumber primary key
eavEmpID foreign key to tblEmployees.empEmpID
eavDate date available
eavFromTime
eavToTime
--
Duane Hookom
MS Access MVP
"norma59" wrote in message
...
Hi,
I have been trying to figure this out myself but just can't figure out the
best way to track employee availability. Employees dictate their schedule
so I need to capture daily availability along with a start time and end time
for each work day they can work. Any suggestions on the best way to do
this?
I have a feeling this is real simple but I just can't think it through
right.
Thanks
|