Create a Query in Microsoft Access to Find Duplicate Entries in a Table

This article was written by MysticGeek, a tech blogger at the How-To Geek Blogs.

First initiate the MDB (Microsoft Database) containing the table you want to check for duplicates.

punch the Queries tab and New.

This will pop crack open the New Query dialog box.

Highlight Find Duplicates Query Wizard then click OK.

Now highlight the table you want to check for duplicate data.

you could also choose Queries or both Tables and Queries.

Once you’ve highlighted the appropriate table click Next.

Here we will choose the field or fields within the table we want to check for duplicate data.

give a shot to avoid generalized fields.

Name the Query and hit Finish.

The Query will run right away and pop up the results.

Also the Query is saved in the Queries section of Access.