Thanks for the quick responses,
Itshim, i have tried using it your way and it works ok if u change the status for every row but if you just change one row it resets the rows that were not set back to nothing? as the query returns
UPDATE joblist SET LostTime = '' WHERE jobCode = 'RS976'
Any...