Total Days Off since the start of the year
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):
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.