O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required