How do I compare addresses between two tables?

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

Guest

I have two systems that I need to keep in sync at all times. Mailing
addresses are updated regularly in one system, and I export the names and
addresses from both systems weekly. I need to set up a report that will
analyze both tables and let me know which records don't have matching
addresses. I will use the same type of reporting method to catch data that
is erroneously entered in one system and use the two tables as a check and
balance type of scenerio. Please help!!!
 
JessHR said:
I have two systems that I need to keep in sync at all times. Mailing
addresses are updated regularly in one system, and I export the names
and addresses from both systems weekly. I need to set up a report
that will analyze both tables and let me know which records don't
have matching addresses. I will use the same type of reporting
method to catch data that is erroneously entered in one system and
use the two tables as a check and balance type of scenerio. Please
help!!!
Click to expand...

How about a query showing both tables and use a criteria under Address1
as "Not [Address2]"
 
You must log in or register to reply here.

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

Child Table With Two Parent Tables 4
Comparing two tables 6
Excel Comparing two columns 1
Compare two table fields. 3
Comparing tables 2
Creating Summary Reports from Two Tables 2
Combining two tables with no matching field name 8
Link Two tables 1

Back
Top