Results 1 to 5 of 5

Thread: Employee Shifts

  1. #1
    Join Date
    Oct 2004

    Unanswered: Employee Shifts

    Does anyone have experience with this???

    I need to create a DB to input and track employee's shifts...we are a 24 hour company with varying shift lenghts(10hr, 6hr, 12hr etc.) and some are reoccurring and some are random...any thoughts??

  2. #2
    Join Date
    Sep 2004
    Tampa, FL
    Bit of a genralazation there. Since the Data model comes first here is a link to tons of data models there is like one that you will be able to use.
    Data models
    If you have specific questions let us know and we will help out.

  3. #3
    Join Date
    Oct 2004
    There would be:
    Employee Table with E_ID & E_Name
    Shift Table with E_ID, E_Name, Date, Start_Time, End_Time

    Basically, at the beginning of each month, the master user will input everyone's shifts.
    I would like a calendar style print out of the shifts...

    There can be up to five employees on the same shift...also, some employees work a recurring shift and I would like to be able to have that auto generate in the months ahead.


  4. #4
    Join Date
    Dec 2004
    Why not have a table with number of hours with an ID
    employee table
    Shift table - employeeID, HoursID, Start Time, Date
    Query - employeeID, HoursID, Start time, EndTime:[StartTime]+HoursID using DateDiff

  5. #5
    Join Date
    Oct 2004
    That sounds like a good idea...
    I guess my biggest concern would be to develop the recurring capability...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts