HELP!? Accrual of numbers by date??

[alexi]

Can anyone help with this one?

I need to accrue Annual leave for full time employees.
It would be at the rate of 0.0547945 every day for 365 days to equal the 20 days of annual leave granted.

i need something to work out for each day then add that number to a running sum next to each employee name, and then a form or somethin to enter when leave is taken, and subtract it from the running sum?

is this at all possible?

any help appreciated.

TA

 

[ghudson]

You might want to check out the Vacation Tracker sample posted at Utter Access

You must join Utter Access to download the sample from the Access Archives. Membership is free and it is worth it.

HTH

 

[alexi]

thankyou for that but that is very complicated yea?
is there any function (simple) that u know of to perform this task?

 

[neileg]

You have double posted this question. This gets people pretty hacked off, and may result in you having less rather than more help!

Hope my answer on the other posting points you in the right direction!

 

[alexi]

sorry

sorry mate i am new to this thing i didnt realise it was an unspoken law. sorry again!