Checking record field by field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to update each record field by field when the field is null or has a
different value. What is the best code to accomplish this task.
 
Hi,
You could use an Update query perhaps.
As to code, you can open a recordset and update fields that way.

You'll have to supply a lot more detail if you want a more detailed reply.
 
I have two tables lets say each with 5 fields. Each table has the same
fields; however, I want to check the values in each field from table 1 with
the same field value in table 2. If the value in table 1 is null or not
equal to the value in table 2 then I update the table 2 field value into the
table 1 field. I continue field by field until all of the fields have been
compared and updated. The next record is then read and the same comparison
is performed, this continues to the end of the file. I know how to write
record updates; however, how should I best handle the field by field
comparison for each record. Thanks
 
Back
Top