Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Find duplicate records with a query

Duplicate data often creeps in when multiple users add data to the Access database at the same time or if the database wasn’t designed to check for duplicates. Duplicate data can be either multiple tables containing the same data or two records containing just some fields (columns) with similar data. Here’s how you can locate duplicate records for a desktop database.

Find duplicate records

To find duplicate records using the Query Wizard, follow these steps.

  1. On the Create tab, in the Queries group, click Query Wizard

  2. In the New Query dialog, click Find Duplicates Query Wizard > OK.

  3. In the list of tables, select the table you want to use and click Next.

  4. Select the fields that you want to match and click Next.

  5. In the list of available fields, select the field or fields that contain the data that you want to update and click Next.

  6. Accept the suggested query name or enter a name, and click Finish to run the query.

After you locate duplicate records, you can either edit or Delete duplicate records with a query.

To locate duplicate records from multiple tables, create a union query.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!