426,122 Members | 921 Online
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

# Vacation Time Off Accrual in MS Access 2010

 P: 27 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 Mar 21 '18 #1

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
Expand|Select|Wrap|Line Numbers
1. Country    YOS*  LvDays
2. UK            1      22
3. UK            2      23
4. UK            3      24
5. UK          100      25
6. France      100      25
7. Costa Rica    5      12
8. Costa Rica    8      14
9. Costa Rica   10      15
10. Costa Rica  100      16
11.
12. *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.

6 Replies

 Expert Mod 2.5K+ P: 3,210 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! Mar 21 '18 #2

 P: 27 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! Mar 21 '18 #3

 Expert Mod 2.5K+ P: 3,210 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 Expand|Select|Wrap|Line Numbers 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. Mar 22 '18 #4

 P: 27 Hello twinnyfo, Thank you so much! That's a start I will continue from here. Cheers! Mar 22 '18 #5

 Expert Mod 2.5K+ P: 3,210 My pleasure. Let us know if there are additional advancements/questions. Mar 22 '18 #6

 P: 27 For Sure, I will if I have more questions and post the final result as well. Thank you. Mar 22 '18 #7