Home > Sample chapters > Microsoft Office > Access

Creating Queries in Access 2010

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.

    httpatomoreillycomsourcemspimages613738.jpg
  5. Click the table in which you want to find duplicate information.

  6. Click Next.

    httpatomoreillycomsourcemspimages613740.jpg
  7. Click the field that might contain duplicate information.

  8. Click Add.

  9. Repeat steps 7 and 8 to add any other fields to the query.

  10. Click Next.

    httpatomoreillycomsourcemspimages613742.jpg
  11. Click any other field you want to display in the query results.

  12. Click Add.

  13. Repeat steps 11 and 12 as necessary.

  14. Click Next.

    httpatomoreillycomsourcemspimages613744.jpg
  15. Type a name for the query.

  16. Click Finish.

    httpatomoreillycomsourcemspimages613746.jpg