Microsoft® Office Access™ 2007 Plain & Simple

Finding Duplicate Records

The standard select query locates records that meet a criterion, such as orders made by a particular customer during a given month. However, you might also be interested in finding those customers who placed more than one order in a month. If all orders for a month are recorded in the same table, you could create a Find Duplicates query to locate CustomerID values that occur more than once in the table.

Create a Find Duplicates Query

1. Click the Create tab.

2. Click Query Wizard.

3. Click Find Duplicates Query Wizard.

4. Click OK.

5. Click ...