Finding Duplicate Fields

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

In the Database window, click Queries on the Objects bar, click New, and then double-click Find Duplicates Query Wizard.

Choose the table or query that you want to search for duplicate records.

Click Next to continue.

Select the field or fields that might contain duplicate information.

Click Next to continue.

Select any other fields that you want displayed in the query.

Click Next to continue.

Enter a name for the new query.

Specify whether you want to view the query results or further modify the query design.

Click Finish.