Finding Discrepancies Between two tables

  • Thread starter Thread starter IrishRed
  • Start date Start date
I

IrishRed

Hello,
I am working on a project to take two unlike tables and make them as like as
possible so that I can compare them and report any discrepancies.

I have made them as 'like' as I can so that I can do the compare. When it
comes to discrepancies I am struggling a little bit. I am able to do one
compare where I do a join on two fields and tell access to show me all from
query one and only those from query2 where the joined fields are equal. I
think that I would need to do more but I am just not sure what approach to
take to get any other discrepancies.

Just looking for some suggestions on the right direction to take this.

Thank you very much for your time.
 
Try this method. First build a union query to result in a complate list of
common field(s).
SELECT [Change Requests].[Date open]
FROM [Change Requests]
UNION SELECT [Change Requet-1].[Date open]
FROM [Change Requet-1];
Then a second query to find records not in both.
SELECT Date_Open_list.[Date open], [Change Requests].[Date open], [Change
Requet-1].[Date open]
FROM (Date_Open_list LEFT JOIN [Change Requests] ON Date_Open_list.[Date
open] = [Change Requests].[Date open]) LEFT JOIN [Change Requet-1] ON
Date_Open_list.[Date open] = [Change Requet-1].[Date open]
WHERE ((([Change Requests].[Date open]) Is Null)) OR ((([Change
Requet-1].[Date open]) Is Null));
 
Back
Top