Compare two tables

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
 
A

Alex Dybenko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare 2 Tables 1
Please Help: compare values in two columns present in seperate tab 2
compare 2 tables 2
Compare table definitions 1
Comparing data in two different tables 3
Compare Two Tables 1
Populating field based on comparison of two lists 4
compare data bases 3

Top