Show only fields that DONT match in two recordsets
Posted on 2012-03-16
Basically I have two tables. One table called RC (tblReportCard) and another one called RCC (tblReportCardChanges). I have a VBA function that inserts the RC records in RCC whenever the user makes any changes of many fields. For instance if the user makes a change to CarrierCallCount I insert the entire recordset into RCC. That all works fine. Now what I want to do is to be able to get only the fields that do not match. the inner joins are on CarrierCode, ReportMonth, ReportYear. both tables have the exact same field names. So if only one of four fields are different I only want to see the one that is different. I did a query with a bunch of ORs but then it shows ALL of the fields. I want to exclude the fields that match in both tables in my query.