AnsweredAssumed Answered

Time off acrruals

Question asked by EP on Dec 10, 2013
Latest reply on Dec 16, 2013 by philmodjunk


Time off acrruals


     Trying to finish a Human Resources file.  I have a Personnel table and a Personnel history table.  I am trying to track vacation day accruals.  I have a TimeOff table (which I think I might merge with the Personnel History table) that allows a user to enter Time Off Events.  On the Personnel table, I have a field called TimeOffAllowed and a field called EffectiveDate- these fields allow the user to enter the amount of vacation time an employee is allowed and went it when into effect.  I need help in creating a calc field that will use those 2 fields to determine how much time an employee has accrued (monthly accruals). Thanks