Vacation Time Off Accrual in MS Access 2010

[ivonsurf123]

Hello,

Really sorry not to bring a code, but really I do not have any idea on how to start this calculations, if you can teach me on how to do it to learn I will appreciate it. This are the requirements for each country:

UK:

Base leave = 22 days when start a job
For first 3yrs add 1 day per year till Max 25 days

Year runs January to December


France:

The annual leave is 25 days (regardless of tenure or position)

Year run from 01 JUN - 31 MAY (the following year)


Cost Rica:

Accrue 1 day per month until your 5 year anniversary, for which you get two extra days each year until you have your 8th year anniversary, then you will get 3 days each year until you have your 10th anniversary for which you will have 4 extra days per year and it stops there.

At the end of each year you cannot have more than 24 days accrued.

Year Days Per Year
1 12
2 12
3 12
4 12
5 14
6 14
7 14
8 15
9 15
10 16
11 16

You max out at 16 days per year starting your 10 year anniversary
Leave can also be carried over till MAX of 24days per year.

Year runs January to December.

Calculation for above:
1. 1-4yrs = 12 days (1day/year)
2. 5-7yrs add 2 days to base of 12 = 14days
3. 8-9yrs add 3 days to base of 12 = 15days
4. 10yr > add 4 days to base of 12 = 16days max

[twinnyfo]

ivonsurf123,

We would love to help you, but you will have to provide at least a little more for us to go on. Are these calculations for a report? To be saved in a Table? To be added to an employee's record?

I think the calculations themselves are manageable enough, but we don't know how you plan to implement any calculations, so we don't know where to start.

Thank you. Hope we can hepp!

[ivonsurf123]

Hello Twinnyfo,

The calculations is to create a table where the data will be save, but also a form to introduce some data like employee name and ID, start date to start calculating first on how many days of vacation that employee will be starting with and depends in the country adding 1 day per year or for CostaRica if you see is different, you will have 12 days per year for the first 4 years and after that it will be raised 2 days for another 3 years (2 days per year) and in year 15 it will be raised ( 1 day) until get to the Max which is 16 days per year.
Really sorry that I do not have a clue how to start these calculations and not to provide a starting code, if I can get help to teach me how to, that will be awesome!

[twinnyfo]

ivon,

My initial thoughts are that you may have much of what you need already, but not in a usable form. You may be able to create a table that simply lists all the potential situations:

tblLeaveCalc

Country    YOS*  LvDays
UK            1      22
UK            2      23
UK            3      24
UK          100      25
France      100      25
Costa Rica    5      12
Costa Rica    8      14
Costa Rica   10      15
Costa Rica  100      16
 
*Years of Service

Then, to determine how much leave an employee earns, simply determine how many years of service the employee has and which country they work in. Then, find the number of days of leave if the employee's years of service is less than the Table's YOS. Notice the values of 100, which implies that the employee will not have worked there more than 100 years, but if they have worked for 15 years, they will earn that amount of leave per year.

This does not take into account when the employee receives their leave alottment, that is, do they receive a full amount on their anniversary date, on the beginning of the calendar year, etc. But those are things outside the immediate scope of your question.

Hope this hepps and can put you in the right direction.

[ivonsurf123]

Hello twinnyfo,

Thank you so much! That's a start I will continue from here.

Cheers!

[twinnyfo]

My pleasure. Let us know if there are additional advancements/questions.

[ivonsurf123]

For Sure, I will if I have more questions and post the final result as well. Thank you.