Hello,
I am using Access 2002 to track payroll. I am trying to carry a
person's Sick time accrued into the next record for an individual. I
am a beginner with access.
I am using the following terms:
SickUsed: Sick time used in a given pay period. (Cannot exceed
SickAccumulated)
SickAccumulated: SickAccumulated through previous month minus SickUsed
(A person can only use sick time accumulated through previous
payperiod)
SickEarned: TotalHours Divided by 79.9 or if TotalHours is greater
than or equal to 80, then SickEarned is 4
SickBalance: SickAccumulated Plus SickEarned minus SickUsed (Current
Month)
Here is my main question: I want the SickBalance from the current
record to become SickAccumulated when a new payroll record is entered
for a person. Is there a way to make Access do this?
Thank you,
Kgatchell2001