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.
Step1:-Table is created with name "PARTY", having 4 fields with 1 primary field "ID_OtherComp"
Step2:-Table is created with name "REG", having 4 fields with 1 primary field "UTI_Extract".
Step3:-Create a query, this will provide all the mismatched records that are not present in second table.
Step4:-Create a query, this will provide all the mismatched records that are not present in first table.
Step5:-Final query is created, which reviews each row of data and returns records with any mismatch from both tables. Basically it is an UNION of first and second query.
DISCLAIMER
It is advised that the information provided in the article should not be used for any kind formal or production programming purposes as content of the article may not be complete or well tested. ERP Makers will not be responsible for any kind of damage (monetary, time, personal or any other type) which may take place because of the usage of the content in the article.