How to Use the Wizard to Create a "Find Duplicates" Query in Microsoft Access

Use a Find Duplicates query to discover whether your tables contain duplicate records. With the wizard, creating the query is just a matter of answering some questions. These instructions apply to Access 97.

Difficulty: Moderate

Instructions

Things You'll Need:

• Microsoft Access

1. Open the Database window.

2. Click the Queries tab.

3. Click New. The New Query dialog box appears. Click Find Duplicates Query Wizard. Click OK.

4. Follow the wizard's instructions to determine what you want to do with the duplicates. Click Finish when all the information is entered.

5. View your query.

Tips & Warnings

• You can delete duplicate records manually by selecting the record and pressing the Delete key.
• Microsoft Access can delete duplicate records automatically, but it cannot be accomplished through the Find Duplicates Wizard.
• You must have the Advanced Wizards installed on your computer.