Jump to content

Calculation of Annual Leave Entitlement


This topic is 1810 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello Guys.

I want to create a Calculation that will do the following

Each worker is entitled to 45 days holiday per year The standard annual leave entitlement for a full-time member of staff is 45 days including public holidays and customary days.

I would just like to be able to put his start date in a filed and then automatically generate how many days holiday he would be entitled and how many days remaining and the end date

I want to keep a history table for each worker when he took his leave and how many days he have.

Like this

1- Emp_Id emp_name , start_date , end_date , total_days, rem_dates

Hope this is enough info.

Thanks in advance.

Link to comment
Share on other sites

The vacations history table needs only these fields:

• EmpID

• StartDate

• EndDate

• cTotalDays (calculation)

The calculation of remaining days should be done in the Employees table. Calculate how many years the employee has been employed, multiply by 45 and subtract Sum ( Vacations::cTotalDays ).

Link to comment
Share on other sites

Thank you very much for taking the time to reply to me. I really appreciate it

Can you please write The formula how to do the Annual leave calculation

and the The vacations history table .

Link to comment
Share on other sites

  • 9 years later...

This topic is 1810 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.