Employee Schedule DB

[Kate]

I was asked if I could create a schedling db. Mainly to spit out a report to
show who should work what days, what shift. There's 6 employees, 3 different
shifts, 7 days a week. Each emp gets two days off in a row and cannot work a
double shift. I need to know how would it be possible to have a report that
tells me who is available for which shifts and who has off when? Is this too
much for access to handle...is this something that should be done in Excel.
Please help...I have no idea where to begin.

Thanks in Advance. Kate

 

[Jeff C]

Each employee works a random 3 on two off schedule..an advanced programmer
could probably write the expression to automate the random rotation, but more
than likely the schedule will change routinely anyway. Access can grenerate
the reports just fine. You will have to build the availability of each
employee into the database on your own.