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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.