Help - Vacation Accural formula

[Jannie]

Our company accures vacation in this manner.
This is how I have my table set up:

Hire Date - date field
Accured Vacation - number field (double)

An employee begins accuring vacation on the Hire Date. After 6 months of
service. the employee becomes eligible to use his vacation. If his Hire
Date is on or before the 15th of the month then you would count that month in
the formula. If he starts after the 15th you don't count it. It is accured
in days not hours.

Please if someone could write this formula for me so I can put it in my
field Accured Vacation. Also I need to create a field called "Vacation Used"
and Another field showing "Vacation Available" for the employee to use.

Thanks for you help. If you write this in code, then I need serious step by
step help on exactly where to put the code. Thanks - Jannie

 

[Steve Schapel]

Jannie,

Normally you would not have an Accrued Vacation field in a table. This
is an unusual requirement, and will lead to difficulty. Similarly with
your suggestions about Vacation Used and Vacation Available. This is
not how databases work. These are figures which are derived from
existing data, such as the Hire Date, and also from your records of
vacation dates, and can be returned whenever you need them, via a query
probably, but should not be stored in a table.

You did not mention the way in which the vacation accrual is calculated.
Can you explain this please? Maybe some examples would help.

And then, I suppose you have another table for vacations taken?
Normally this would involve fields such as:
EmployeeID
VacationDateFrom
VacationDateTo

 

[peregenem]

And then, I suppose you have another table for vacations taken?

And then a Calendar table to know which of the days between
vacation_start_date and vacation_end_date were non-work days/hours:
weekends, public holidays, etc?