asked on Vacation Accrual Calculation using MS-Access
I am trying to construct an Access database that will allow for the calculation of vacation days accrued for employees using the criterion below
Status = Established
under $25,692 per year = 21 days (1.75 per month)
$25,692 and under $35,544 per year = 28 days (2.3 per month)
$35,544 per year and over = 35 days (2.9 per month)
Status = Un-established
1 - 2 years service = 14 working days
3 - 5 years service = 21 working days
6 - 10 years service = 28 working days
over 10 years service= 35 working days
Status = Contracted
under $24,000 per year = 15 working days
$24,000 to $41,988 per year = 20 working days
over $41,988 per year = 25 working days
It is hoped that the employee status and salary would be somehow used to determine the vacation days they are entitled to. The accrued days will also be deducted from holidays granted to employees and recorded in a calculated filed to ensure an accurate balance is kept. Can anyone help?
The basic staff table has the following fields:
Staff_ID
Name
Division
Salary
Status
Start Date
Status = Established
under $25,692 per year = 21 days (1.75 per month)
$25,692 and under $35,544 per year = 28 days (2.3 per month)
$35,544 per year and over = 35 days (2.9 per month)
Status = Un-established
1 - 2 years service = 14 working days
3 - 5 years service = 21 working days
6 - 10 years service = 28 working days
over 10 years service= 35 working days
Status = Contracted
under $24,000 per year = 15 working days
$24,000 to $41,988 per year = 20 working days
over $41,988 per year = 25 working days
It is hoped that the employee status and salary would be somehow used to determine the vacation days they are entitled to. The accrued days will also be deducted from holidays granted to employees and recorded in a calculated filed to ensure an accurate balance is kept. Can anyone help?
The basic staff table has the following fields:
Staff_ID
Name
Division
Salary
Status
Start Date
Microsoft Access
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
generous vacation plan, can I come work for you?
ASKER
Thank you so much for your speedy response but I am afraid that I am still a bit lost. I have been trying to run the function in a query but not sure of the syntax and getting no results. I am sure that the error is on my part - can anyone assist.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
So far I have nothing. I was hoping to get a semi-complete solution that could be modified to fit my needs.
The accrual should run at the end of each month and would be based on both the employee status and the salary earned. A separate table is required to document the running balance and all deductions made over time (something like a sub-form I guess).
Any help that can be provide inclusive of the additional table structures will be greatly appreciated. I am an Access rookie and this solution is gravely needed. Thanks again for your help.
Thanks Crystal.. I really do appreciate the solution provided.
The accrual should run at the end of each month and would be based on both the employee status and the salary earned. A separate table is required to document the running balance and all deductions made over time (something like a sub-form I guess).
Any help that can be provide inclusive of the additional table structures will be greatly appreciated. I am an Access rookie and this solution is gravely needed. Thanks again for your help.
Thanks Crystal.. I really do appreciate the solution provided.
Hi Gerard,
> "Access rookie"
I guess the VBA code is kind of like being in the ocean when you don't know how to swim ...
instead of using a query to start ... maybe a form? Create a command button on the form and set these properties:
Name = cmdTest
Caption = Test
when you are in the Design View of a form, whatever you click on will show values in the Property sheet. Explore what you can set.
If the Property sheet is not displayed, press Alt-Enter to turn it on
Once you have created the command button ... that actually doesn't do anything yet, post back for the next step
> "Access rookie"
I guess the VBA code is kind of like being in the ocean when you don't know how to swim ...
instead of using a query to start ... maybe a form? Create a command button on the form and set these properties:
Name = cmdTest
Caption = Test
when you are in the Design View of a form, whatever you click on will show values in the Property sheet. Explore what you can set.
If the Property sheet is not displayed, press Alt-Enter to turn it on
Once you have created the command button ... that actually doesn't do anything yet, post back for the next step
poster was lost implementing VBA