Microsoft Access – finding duplicate records

If you want to find duplicate entries in a field in a table or query, the easiest way to do this is to use the Find Duplicates Query Wizard. For example, you may wish to find records with the same name but different addresses, or as in the example below, which suppliers are in the same city.

To use the Find Duplicates Query Wizard

If using Microsoft Access 2007 or Microsoft Access 2010, click the Create tab, and then in the Other group, click Query Wizard. If using Microsoft Access 2003 or earlier, from the Database window, click the Queries object button, then click New.  In the New Query dialog box, select Find Duplicates Query Wizard, then click OK.

The New Query dialog box will be displayed.

 

In the New Query dialog box, select Find Duplicates Query Wizard, then click OK.

Select a field which might contain duplicate information, then click . Repeat for any other fields that may contain duplicate information, then click Next.

Select any other fields that you want included in the query results, then click Next.

Provide a name for your query, then press Finish. Duplicate records will be displayed

To find out more about our Microsoft Access training courses Sydney, Australia, please visit http://www.jmdtraining.com.au/microsoft-office-training/microsoft-access-training.

To find out more about our Microsoft Access training courses London, UK, please visit http://www.jmdtraining.co.uk/microsoft-office-training/microsoft-access-training

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010 and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s