M
Melinda
I have an overtime database which tracts overtime. At the end of the year
we equalize the overtime. We have to subtract the lowest employee from the
highest employee by Class No. When I create an update query how do I sum
the hours worked and subtract off the hours I am rolling that employee back.
I tried sum[hoursworked]-458.0 and i still get 10 records for that employee
instead of that paticular employees hours being summed. The query runs as
if it going to subtract 458 off each and every line. I would appreciate any
help.
we equalize the overtime. We have to subtract the lowest employee from the
highest employee by Class No. When I create an update query how do I sum
the hours worked and subtract off the hours I am rolling that employee back.
I tried sum[hoursworked]-458.0 and i still get 10 records for that employee
instead of that paticular employees hours being summed. The query runs as
if it going to subtract 458 off each and every line. I would appreciate any
help.