Find Duplicates Query Wizard:
This Wizard creates a query that finds records with duplicate field values in a single table or Query.
Steps :
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv2kkGhqQVUq6sQtRMeO4ZtvypwTq9XAOq8B8hTMpvkMzhOvqCjNeoMjUFDa6-oke7ZMIj2zQdzplJB_uxj0wSr_8PXebyGu0LrQgqaDBhq4xBet9wHAkCvS9oQpflkYq0Lbisc9DDChM/s640/Find+D.jpg)
Follow @Sarvavasi.com
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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv2kkGhqQVUq6sQtRMeO4ZtvypwTq9XAOq8B8hTMpvkMzhOvqCjNeoMjUFDa6-oke7ZMIj2zQdzplJB_uxj0wSr_8PXebyGu0LrQgqaDBhq4xBet9wHAkCvS9oQpflkYq0Lbisc9DDChM/s640/Find+D.jpg)
- Click on Create Tab
- Then click on Query Wizard
- Choose the “Find Duplicates Query Wizard”
- Click on Ok Button
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif0ezq8wYgS8sGP0dJdRnnGiGlhrbTN3tyVw_VzcdURhKP_urUCM9ros-S4z4SHGmAKLcwKbR0k1QbVJ2TCf2ub9sMLPZNQz78gpVbWuC1jbtGYuT2v4mAhKEOnX00nkTNJRmBNeuKqCU/s400/Find+D+1+.jpg)
- Click on Next button
- Type the Query Name
- Click on Finish Button
Result Table:
Follow @Sarvavasi.com