I am working in Access 2010.
I have a query that has these fields: (please see screen shot).
The goal is to compare records in this query based on four fields and dump the duplicate record based on the value of a fifth field:
If ALL of the below four fields are identical....
the fifth field
determines which record will be dropped and which record will stay of the duplicate records.
The [Source] field will always have one of two entries: Susie OR FMS. FMS should be the winner in all duplicate records.
I hope there is a simple way to solve this!