C
Celest
I have a table that tracks # of hrs employees take off from work. The table
has
the following fields: ID, DateOfEntry, TypeOfLeave, DateRequested,
HrsRequested, TotalHrs, and HrsBalance. I need to populate the Hrs Balance
field based on the code entered in the type of leave field(DDD=16 hours,
DDP=8 hours), and the HrsRequested field. Ex. ID# 222222: [Type of
Leve]"DDD", 16-4=12.
ID# 222222: [Type of Leve]"DDD", 12-3=9.
I can't find a way to keep subracting from the remaining balances(12Hrs).
Please help
has
the following fields: ID, DateOfEntry, TypeOfLeave, DateRequested,
HrsRequested, TotalHrs, and HrsBalance. I need to populate the Hrs Balance
field based on the code entered in the type of leave field(DDD=16 hours,
DDP=8 hours), and the HrsRequested field. Ex. ID# 222222: [Type of
Leve]"DDD", 16-4=12.
ID# 222222: [Type of Leve]"DDD", 12-3=9.
I can't find a way to keep subracting from the remaining balances(12Hrs).
Please help