RE: Employee Schedule DB
From: Jeff C (JeffC_at_discussions.microsoft.com)
Date: 01/07/05
- Next message: Sprinks: "RE: validate a field by another table"
- Previous message: wz: "validate a field by another table"
- In reply to: Kate: "Employee Schedule DB"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 Jan 2005 12:27:06 -0800
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.
"Kate" wrote:
> 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
- Next message: Sprinks: "RE: validate a field by another table"
- Previous message: wz: "validate a field by another table"
- In reply to: Kate: "Employee Schedule DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
