D
davea
Hello
I have a form setup that calculates total rates for time worked on a
job, e.g. hours worked on a job * an employees pay rate. The employees
pay rate is pulled from a subform that pulls through the employees
"current" pay rate. It works fine apart from when I have to change an
employees pay rate. When this is changed all the data entered into my
main form is recalculated with this new pay rate for all associated
records.
I want to be able to save this data with the employees old pay rate so
that historical data for the job reflects the change in pay rate. I've
set up the pay rates and jobs with start and end dates.
Any suggestions anyone?
I have a form setup that calculates total rates for time worked on a
job, e.g. hours worked on a job * an employees pay rate. The employees
pay rate is pulled from a subform that pulls through the employees
"current" pay rate. It works fine apart from when I have to change an
employees pay rate. When this is changed all the data entered into my
main form is recalculated with this new pay rate for all associated
records.
I want to be able to save this data with the employees old pay rate so
that historical data for the job reflects the change in pay rate. I've
set up the pay rates and jobs with start and end dates.
Any suggestions anyone?