Microsoft Office Tutorials and References
In Depth Information
Finding Duplicate Records
5. Choose the fields to be shown for additional information in the third
window of the wizard and then click Next.
The fields you specify aren’t used for comparing records, but they
appear in the query results to help you better identify any duplicate
records. If your table has a primary key and/or Date Entered field,
both are good candidates for this third field.
6. Give the query a name.
Change the suggested name for the query, if you want, or select the
suggested name in the last window of the wizard.
7. Choose the View the Results option.
8. Click the Finish button.
The results of the query appear in Datasheet view. If no records appear, no
records have identical values in the fields you specified in the wizard. You
have nothing to worry about.
On the other hand, if records do appear, you know that you have
duplicates. In Figure 3-13, for example, two records for Frankly Unctuous appear.
Note the identical First Name, Last Name, and Address1 fields. The
ContactID field allows you to see that two records for this customer are
indeed in the table.