Lesson 6.10. Finding Duplicate RecordsFigure 6-19. Step One: Select the table or query in which you want to search for values.![]() Figure 6-20. Step Two: Select the field or fields that contain the duplicate values.![]() Figure 6-21. The query displays those records that have duplicate values in both the LastName and FirstName fields.![]() The helps you find records that have the same value in one or more fields. So when would you need to use a Find Duplicates Query? Here are a few scenarios:
Access provides a wizard to make creating a query that finds duplicate information in a snap. "Arrr-rrgh!" you shout as you realize that you and another co-worker have just entered the same customers into a database. Fortunately, you can find the duplicated records by using the Find Duplicates Query Wizard.
|