Hi CTBarbarin,
According to your description, if you have two Access desktop databases, or maybe two versions of the same database, and you want to compare them to find design changes to queries, forms, or reports. Or maybe you want to find the differences in Visual Basic
for Applications (VBA) code modules. If you have Microsoft Office Professional Plus 2013 or 2016, you can use Microsoft Database Compare to run a report on the differences it finds.
For more information, click
here to refer about Basic tasks in Database Compare
If you want to review records from one table only if there are corresponding records in another table that contain one or more fields with matching data.
Create a query that joins fields from each table where those fields contain corresponding information, either by using an existing relationship or by using a join that you create for the purpose of the query. This method provides optimum performance (the
speed with which the query returns results), but you cannot join fields that have dissimilar data types.
Create a query that compares fields by using one field as a criterion for the other. Using a field as a criterion for another field is generally slower than using joins, because joins eliminate rows from a query's results before the underlying tables are
read, whereas criteria are applied to a query's results after the underlying tables are read. However, you can use a field as a field criterion to compare fields that have dissimilar data types, which you cannot do by using joins.
For more information, click
here to refer about Compare two tables and find only matching data and
here to refer about Compare two tables and find records without matches
