Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / January 2005

Tip: Looking for answers? Try searching our database.

Employee Schedule DB

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kate - 06 Jan 2005 19:12 GMT
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 - 07 Jan 2005 20:25 GMT
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.

> 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
[quoted text clipped - 5 lines]
>
> Thanks in Advance.  Kate
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.