Comparing two tables

  • Thread starter Thread starter veronicr
  • Start date Start date
V

veronicr

Guest
I have two different tables. There are similiar fields in both tables and the primary key is the SSN. I need to eventually print out a report that shows this data from each table, side by side. All I want is a report that will show the results from the 1st table and the 2nd table side by side so that the user can see the discrepancy. I don't use Access much and am a beginner. From time to time, I will update and replace both tables, run the query, run the report and use this for "data validation" so the user can see the discrepancy.
 
Create a new query and add both tables to the query and join them on the common field, probably an ID. Then drag the fields you want from each table to the QBE grid. Save the query then make a report based on the query placing the fields from each table they way you want them to be displayed....
 

Users who are viewing this thread

Back
Top Bottom