View Single Post
  #2  
Old July 13th, 2004, 02:55 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default 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