Compare two tables

  • Thread starter Thread starter Trusty
  • Start date Start date
T

Trusty

Hi everyone, I have a db with two tables that I want to
compare based on three fields that are identical. If the
fields match I want to update a flag (chkBox) to true. The
issue I am having is that if there are duplicates of
entries in any of the tables all the dupes are being
flaged true aswell. I am new to vba and was wondering how
would I be able to open the two tables as two different
recordsets and compare them that way.

Regards
 
i think you can do this with Update query
you can join 2 tables using all 3 fields, and then use result of join in
update query
 
Back
Top