In order to have a query you can update, I have made the (Select Distinct) query an append query and write the records into a work table. Then I can use that table (the work table) and the table I NEED to query, make a join between the two on AuditID and you should be able to check the check box that you need to be checked.