Article ID: 209183 - View products that this article applies to.
This article was previously published under Q209183
For a Microsoft Access 97 version of this article, see 109329Novice: Requires knowledge of the user interface on single-user computers.
This article describes how you can remove duplicate records from a table by using primary keys. By using this method, you can check for duplicate values in up to 10 fields in the table.
To remove duplicate records from a table, follow these steps:
For more information about deleting duplicate records, click Microsoft Access Help on the Help menu, type Automatically delete duplicate records from a table. in the Office Assistant or the Answer Wizard, and then click Search to view the topic.