AnsweredAssumed Answered

Total Days Off since the start of the year

Question asked by hrcap on Aug 13, 2013
Latest reply on Aug 15, 2013 by hrcap

Title

Total Days Off since the start of the year

Post

     Evening All

      

     I require some assistance if possible please.

      

     I have a database of employees (Table name: EMPLOYEES), i can add time off that any employee has had as one of the following (in a table titled: ABSENCES):

     Accident

     Holiday

     Sickness  (each of these three are stored in a field titled: Type)

      

     For each of the time off records i have a field titled: total_weekdays_off that calculates the total number of weekdays that the employee has missed due to that particular absence.

      

     On each of the employee files i am looking to three fields that gives a calculation for the total number of weekdays that have been taken off in relation to Accidents, Holidays, and Sickness since 01/01/CurrentYear, but i cannot work out how to do this.

      

     Any help would be appreciated.

      

      

     Cheers

      

     Hadleigh

Outcomes