I currently have a form [frmE_PMSA] that has fields dtmDate, intHoursWorked, intHoursToGo, intWeeks, intHoursWeek.
On my form I would like to set up another field that is bound to the table that will upon clicking it, retrieve the data from the previous record [intHoursWeek] and run a calculation against the current records intHoursWorked.
Example:
dtmDate / intHoursWorked / intHoursToGo / intWeeks / intHoursWeek
05/23/05 / 400 / 10000 / 10 / 1000
05/30/05 / 500 / 9500 / 9 / 1056
On my form, I would be showing the most recent data entry for the week of 05/30/05. What I would like to do is have a form field that upon clicking it, will calculate the percent efficiency for that weeks worked performed. In this case the calculation would be:
Efficiency = intHoursWorked(current Record "05/30/05") / intHoursWeek (Previous Record)
Efficiency = 500/1000
If someone can help with this I would appreciate it. Thanks!
On my form I would like to set up another field that is bound to the table that will upon clicking it, retrieve the data from the previous record [intHoursWeek] and run a calculation against the current records intHoursWorked.
Example:
dtmDate / intHoursWorked / intHoursToGo / intWeeks / intHoursWeek
05/23/05 / 400 / 10000 / 10 / 1000
05/30/05 / 500 / 9500 / 9 / 1056
On my form, I would be showing the most recent data entry for the week of 05/30/05. What I would like to do is have a form field that upon clicking it, will calculate the percent efficiency for that weeks worked performed. In this case the calculation would be:
Efficiency = intHoursWorked(current Record "05/30/05") / intHoursWeek (Previous Record)
Efficiency = 500/1000
If someone can help with this I would appreciate it. Thanks!
