Friends,
Newbie
I have a database with:
Tables:
tblEmployee
tblPayment
tblVacation
Query's:
qryEmployee
qryPayment
qryVacation
qryCalculation
tblPayment is updated 2 times in a month
tblEmployee has a field VacationSaldo
On every payment you have additions and possible subtraction of vacationhours.
The addition is called [Ontv]: (NormalHours+15 0%Hours+200%Hou rs)* VacationFactor
The possible subtraction is in tblPayment [VacationOP].
Every payment has a unique PaymentID.
After the payment information is entered the field VacationSaldo in tblEmployee must be updated with the value of the field [Ontv] and [VacationOP].
And when i wil enter a new payment information this must happen again but only for the last entered payment.
It sounds like an inventory.
Can u help me with this please?
See attachment
Newbie
I have a database with:
Tables:
tblEmployee
tblPayment
tblVacation
Query's:
qryEmployee
qryPayment
qryVacation
qryCalculation
tblPayment is updated 2 times in a month
tblEmployee has a field VacationSaldo
On every payment you have additions and possible subtraction of vacationhours.
The addition is called [Ontv]: (NormalHours+15 0%Hours+200%Hou rs)* VacationFactor
The possible subtraction is in tblPayment [VacationOP].
Every payment has a unique PaymentID.
After the payment information is entered the field VacationSaldo in tblEmployee must be updated with the value of the field [Ontv] and [VacationOP].
And when i wil enter a new payment information this must happen again but only for the last entered payment.
It sounds like an inventory.
Can u help me with this please?
See attachment