I have put together a Human Resource database for your company. The HR manager wants me to setup the vacation time field to automatically adjuster it's self each time their vacation changes each year from their Hire Date. My fields are: Date_of_Hire and VTBeginningBalance. Each time their hire date comes around I need it to calculate and fill in the VTBeginningBalance field.
0-1 year no vacation on their 1st anniversary date they get 40 hours.
On their 2nd anniversary they get 80 hours.
And it doesn't change until they reach their 5th year anniversary. On their 5th anniversary they get 120 hours. I need help with the access code and also where to place the code. Do I place it in an event procedure under Date_of_Hire or VTBeginningBalance? I have been trying everything.
Can someone please help me out on this one.