Find Duplicates Query Wizard:
This Wizard creates a query that finds records with duplicate field values in a single table or Query.

Steps :

  • Create table based on below format

  • Click on Create Tab
  • Then click on Query Wizard 
  • Choose the “Find Duplicates Query Wizard”
  • Click on Ok Button

  • Choose the Required table Name (or) Query Name

  •  Click on Next button

  • Choose the Duplicate-value fields (Example : Company Name)
  • Click on Next Button

  • Choose the Additional Query Fields(SupplierID,ContactName,ItemName).
  • Click on Next Button

  • Type the Query Name
  • Click on Finish Button
Result Table: