Results 1 to 4 of 4
  1. #1
    james7705 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2014
    Location
    East London, South Africa
    Posts
    24

    Date and Time management


    Good day...
    I am hoping someone can assist or point me in a direction with regards to managing times in a database.
    Allow me to explain...
    I have 3x tables...
    tblHolidays which contains "HolidaysID", "HolidayName" and "HolidayDate"
    tblEmployees which contains "EmployeesID", "EmployeeName" and "EmployeeLevel"
    tblWorkingHours which contains "WorkingHoursID", "EmployeeName", "Date", "StartTime", "EndTime", "@1", "@1,5", "@2" and "LostTime"
    What I am attempting to do is...

    For level 1 Staff
    On a weekday i.e. Monday thru Friday any time worked other than between 08h00 and 16h30 needs to be captured in a separate column i.e. "@1"
    unless the date matches a date in tblHolidays, in this case if hours worked is less than 8 then 8 hours of worked time needs to go into a column "@1".
    If hours worked is more than 8 then total hours of worked time needs to go into a column "@1".

    Any hours worked on a Saturday needs to go into the "@1" column

    On a Sunday, if hours worked is less than 4 but more than 0, then 4 hours will be logged in the "@" column, else total hours worked will be logged in "@1" column

    For level 2 Staff
    On a weekday i.e. Monday thru Friday any time worked other than between 08h00 and 16h30 needs to be captured in a separate column i.e. "@1,5"
    unless the date matches a date in tblHolidays, in this case if hours worked is less than 8 then 8 hours of worked time needs to go into a column "@1".
    If hours worked is more than 8 then 8 hours of worked time needs to go into a column "@1" and the rest must go into a column "@2".

    Any hours worked on a Saturday needs to go into the "@1,5" column

    On a Sunday, if hours worked is less than 4 but more than 0, then 4 hours will be logged in the "@2" column, else hours worked will be logged in "@2" column.

    TIA

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Crossposted with replies at both AWF and UA

    @James7705 - Please read this article about the etiquette of crossposting - https://www.excelguru.ca/content.php?184
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    james7705 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2014
    Location
    East London, South Africa
    Posts
    24
    My apologies...I did not think of it that way

  4. #4
    james7705 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2014
    Location
    East London, South Africa
    Posts
    24

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 09-16-2018, 04:58 PM
  2. Replies: 2
    Last Post: 10-17-2016, 09:29 PM
  3. Replies: 11
    Last Post: 07-20-2014, 06:22 PM
  4. Time and Leave Management System
    By P5C768 in forum Database Design
    Replies: 0
    Last Post: 03-10-2011, 11:20 PM
  5. PTO Time Management Database
    By Stanggirlie in forum Programming
    Replies: 1
    Last Post: 03-27-2009, 09:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums