• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Finding Duplicate Fields

In some tables, you need to find records that have duplicate values in particular fields. For example, in a table of patient encounters, you might want to discover which patients have multiple encounters. You can create a query that retrieves all the records from the Encounters table that have duplicate values for the Patient Name field. Access provides the Find Duplicate Query Wizard to guide you through each step to help you create the query.

Find Duplicate Records

In the Database window, click Queries on the Objects bar, click New, and then double-click Find Duplicates Query Wizard.

Choose the table or query that you want to search for duplicate records.

Click Next to continue.

Select the field or fields that might contain duplicate information.

Click Next to continue.

Select any other fields that you want displayed in the query.

Click Next to continue.

Enter a name for the new query.

Specify whether you want to view the query results or further modify the query design.

Click Finish.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint