Simulate Full Outer Join in MS Access


Sometimes a problem arises in the condition when there are two reports from two separate sources, the number of fields in each report may vary but there are at least 5 fields that are definitely same in both reports, and the data in these 5 fields should be an identical match. And we want to identify where the data does not match. And we want to bring both records back, in case of mismatch.

This could be achieved using "Full Outer Join". The following article guides you that how to simulate full outer join in MS Access.

The data currently present in tables PARTY and REG.

The following fields in the PARTY table are compared with the fields in the REG table.

  • "ID_OtherComp" in the table PARTY should match field "UTI_Extract" in the REG table.
  • "Party1_OtherComp" in the table PARTY should match field "CP1_Extract" in the REG table.
  • "Party2_OtherComp" in the table PARTY should match field "CP2_Extract" in the REG table.
  • "Val_OtherComp" in the table PARTY should match field "MarketVal_Extract" in the REG table.

 

BUY SERVICES CONTACT LOCAL MANAGERS