AnsweredAssumed Answered

Annual leave Calculation

Question asked by al-kalbani on Aug 29, 2018
Latest reply on Aug 31, 2018 by al-kalbani

Hi all,

          I need help with Calculation if any one have a idea how to do it

I have two Tables, one for Employee and the other for Vacation Table with the following Fields

 

 

( Employee  Table )

_pk_emp_id

_emp_name

_doj

_annual_vacation

_vacation_taken

_vacation remaining

 

 

(Vacation Table)

 

_vacation_id

_fk_emp_id

_Start_date

_End_date

_days_allowed

_days_remaining

 

 

The employee gets an annual leave for 30 days per year from the date of Join

How to Add 30 Days in Employee  Balance Automatically every year by Calculation

Outcomes