Access Duplicate Records Help

[Sohan]

Hi,

Wonder if anyone can help with a query in access to find duplicate records based on certain rules.

I have a table of data which contains 7 fields as per the example image.

I need to have a query which does the following :-

Checks the code for duplicate and returns list where items in value 1 or / and value 2 are different between the batch. In this example, it should return records for 845543 and 919071 as value 1 and value 2 are different in the batches. The records returned should be whichever. Is this possible via MS Access.

Any help is appreciated

Thanks,

[June7]

This would be fairly easy if the batches were in different tables then could do a find unmatched query. Because they are in same table, the requirement is to get value from another record in the same table, this calls for subquery. Review: http://allenbrowne.com/subquery-01.html

Look at the example for Get the Value in Another Record.