A
AccessNoob
Still reading my Access Bible. I have created a nice employee-tracking
program for my job and have even gotten it implemented.
I need to build a vacation time tracking macro/code
I have been trying to build a macro that will calculate who has accrued
what vacation time automatically.
I have several fields I am trying to use.
PTO accrual rate: 2.46 (vacation hours added once every two weeks)
Higher date: 10/06/05 (The day they started accruing vacation time)
Used PTO: 5 (How much vacation they have used..if any)
Available PTO time. (What is currently available?)
=sum([PTOrate]*[mystery calendar command, includes start date and
current date] - [UsedPTO]) and runs only every other Friday.
Right now, I just go in with a calculator every two weeks and add 2.46
hours on every employee's page. There has to be an easier way than
having to update 60 pages of info.
It is easy enough to just build a simple addition and subtraction macro
but I have no idea how to tie the function into a calendar.
Can anyone help? Or am I just going about this the wrong way?
Thanks
Noob
program for my job and have even gotten it implemented.
I need to build a vacation time tracking macro/code
I have been trying to build a macro that will calculate who has accrued
what vacation time automatically.
I have several fields I am trying to use.
PTO accrual rate: 2.46 (vacation hours added once every two weeks)
Higher date: 10/06/05 (The day they started accruing vacation time)
Used PTO: 5 (How much vacation they have used..if any)
Available PTO time. (What is currently available?)
=sum([PTOrate]*[mystery calendar command, includes start date and
current date] - [UsedPTO]) and runs only every other Friday.
Right now, I just go in with a calculator every two weeks and add 2.46
hours on every employee's page. There has to be an easier way than
having to update 60 pages of info.
It is easy enough to just build a simple addition and subtraction macro
but I have no idea how to tie the function into a calendar.
Can anyone help? Or am I just going about this the wrong way?
Thanks
Noob