In some tables, you need to find records that have duplicate values in particular fields. For example, in a table of employees, you might want to discover which employees work at the same location. You can create a query that retrieves all the records from the Employees table that have duplicate values for the Office Location field. Access provides the Find Duplicate Query Wizard to guide you through each step to help you create the query.
Find Duplicate Records