Find duplicate records with a query

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007.

Duplicate data usually sneaks in anytime several users append data to the Access database simultaneously or if the database was designated in such a way that omits filtering for duplicates. Duplicate data can appear as either numerous tables including the consistent type of data or two records having merely some fields (columns) with related data. See below to learn how you can discover duplicate records for a desktop database.

Find duplicate records

To obtain duplicate records using the Query Wizard, stick closely to these steps.

  1. On the Create tab, in the Queries group, choose Query Wizard
  2. In the New Query dialogue, select Find Duplicates Query Wizard > OK.
  3. In the selection of tables, choose your desired table to use and press Next.
  4. Pick the fields that you want to match and press Next.
  5. In the collection of available fields, confirm the field or fields that embody your preferred data that you seek to update and press Next.
  6. Accept the recommended query name or type a name, and choose Finish to perform the query.

Once you find duplicate records, you can either edit or Delete duplicate records with a query.

To capture duplicate records from several tables, create a union query.

Leave a Reply

%d bloggers like this: