Lesson 6.10. Finding Duplicate Records
Figure 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.