Microsoft-Access-Day-Eighteen

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:

Follow @Sarvavasi.com