FindDuplicatesBetweenTables

  • Thread starter Thread starter gh
  • Start date Start date
G

gh

I am using Access 2007 and have 2 tables with client information. I
need to compare the Client ID' s in table 1 to the client id' s in table
2 and if they exist in table 2, then print the record or save it to a
3rd table. What would be the best way to do this?

Thnaks
 
In a query
== Add both tables
== Select the fields you want to see
== Set up a join between the two tables by dragging from ClientID in table1 to
ClientID field in table2.

This will then only return records where the identical clientId exists in BOTH
tables.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top