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.