General discussion
December 26, 2002 at 04:17 AM
gcheels

Comparing Records In Two Tables

by gcheels . Updated 23 years, 9 months ago

I have two tables that contain similar data in MS Access. For this example let say they both relate to customer info. Both tables have a field called CustID that I can link the two with. Both tables have missing or different data in the address field and some records have the data missing on both fields in each table. I would like to write a query that will look at both tables and display the records that the address field do not match as well as the instances where there is no data in the address field in both tables. Thanks.

This discussion is locked

All Comments