How to get duplicate records using sql query
Top sites by search query "how to get duplicate records using sql query" http://www.databasejournal.com/features/msaccess/article.php/3077791/Delete-Duplicate-Records-From-Access-Tables.htm You can download a copy of the code for this article and give it try yourself but basically, this is the process: Load a sorted recordset with the duplicate fields. The issue had never plagued me personally, possibly because of the way I design my databases, but more likely because my applications were simply not the type that tend to collect duplicates