Compare two tables

[construction access noobie]

I work in the construction industry. My problem is that I have 2 tables. One
contains the base set of specifications and the other the actual used
specifications. All fields and the number of records are identical. I need to
compare the various records for differences and generate a new table with the
differences.

Any help would be greatly appreciated.

 

[John Nurick]

Assuming (a) that each record in the "base" table has one and only one
counterpart in the "used" table, and (b) that both tables have primary
keys, you can do this:

1) create a query and select both tables.

2) in the upper pane of the query design window, drag the primary field
from one table to the other. This joins the tables so each record in the
query gets its data from a pair of records in the tables.

3) use whatever calculated fields you like in the query to reveal and
report on the differences.

If this isn't enough to get started, post back here with some more
information about your data and the table and field names.

 

[construction access noobie]

Thank you John. Your help has been greatly appreciated.

 

[Bao]

HI,
I need to generate a report to show all records that have differences
between 2 identical tables.
After created a query that contains identical fields of each table.
I would like to know how to report only records that have differences.

Please advice,
Bao