If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Employee Schedule DB
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create an employee schedule and vacation tracker? | Excellent | New Users | 2 | October 22nd, 2004 09:34 PM |
I'm looking for: Excel Employee Schedule Sheet... | Keywizz | Charts and Charting | 1 | September 20th, 2004 09:21 PM |
Union query | Raj | Running & Setting Up Queries | 2 | September 17th, 2004 07:46 PM |
Matching data and returning header | matman17 | General Discussion | 2 | July 2nd, 2004 07:57 PM |