I have a overtime database in which the bulk of the data resides in the tblhours which tracks each and every occasion of overtime they have. Once a year, per our union contract, we have to rollback the overtime subtracting the lowest person’s overtime from the each and every employee within their classification. I have tried this numerous ways and I am really struggling here. In my mind I should be able to bring the hoursworked and the class in the a query, change it to an update query subtracting the amount of hours, but it subtracts the total amount from each and every occasion of overtime, so I then in the update line typed =sum[hoursworked]-10.5 and that replaces all the hours in the table with a “0” Can anyone please offer some advice as to how I would achieve this.
