• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 34. Using Queries > Finding Duplicate or Unmatched Records

Finding Duplicate or Unmatched Records

Access provides two wizards that help you find duplicate field values in a table and find records in one table with no related records in another table.

To find duplicate records:

1.
Click the New button on the Queries tab of the Database window toolbar.

2.
In the New Query dialog box, select Find Duplicates Query Wizard (Figure 34.22).

Figure 34.22. Select Find Duplicates Query Wizard and click OK.


3.
Click OK.

4.
Follow the wizard steps to select the table, choose the fields that might contain duplicate information, and select the other fields you want to display.

5.
On the last page, type a name for the query or accept the default name and click Finish.

6.
Run the query (Figure 34.23).

Figure 34.23. The query finds duplicates for employee in charge for each date.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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