I have a database where we take records from a table and create two recordsets. The purpose of this is to compare records from the table where the ID field is equal to the ID we are looking at. Using the two recordsets, we use one of the record sets and go through it, one by one, and compare it to all the records in the second recordset. We have the comparisons working, but we change values in the first record set. My question is, how do we change the values in the actual table based on the changes made in the recordset? Do we need to create a loop to go through the table and change the values where the ID field = the ones in the recordset or is there an easier way to do it?