Employee Vacation Query

[denileigh]

We are changing our employee vacation compensation from an annual basis (every January) to an annual hire date accrual.

This code is working fine...
=IIf([Text208]>240,"160.00",IIf([Text208]>120,"120.00",IIf([Text208]>24,"80.00",IIf([Text208]>12,"40.00","0.00"))))

[Text208] is months employed based on the current date. You cannot carry over vacation though. If you don't use it within the your year you lose it. How do I add that to the formula?

 

[rzw0wr]

This type of math and testing would likely be better carried out in VBA.
You would be asking a lot from a query to do the checking.
You would need to check the year to make sure the year is not over yet.
Check to see how much vacation time an employee has coming.
Check to see if the employee is going into a higher category.

I would do this on a form with VBA.

Dale

 

[jdraw]

I think you have multiple questions/issues best handled separately. I don't see them being part of your current formula.
In my view you have 3 issues:

-Vacation compensation earned based on hire date
-Vacation compensation used within the valid period/ remaining to be used in the valid period
-Vacation compensation lost because of non-use within the valid period.

You may want some report/form/query to advise employees of "vacation that may be potentially lost if not taken before EndOfValidPeriodDate