Difference between Unique Values (DISTINCT) and Unique Records (DISTINCTROW) in Microsoft Access Queries
![Eliminate Duplicates with SQL SELECT DISTINCT | Database Solutions for Microsoft Access | databasedev.co.uk Eliminate Duplicates with SQL SELECT DISTINCT | Database Solutions for Microsoft Access | databasedev.co.uk](http://www.databasedev.co.uk/image/sql_select_results.gif)
Eliminate Duplicates with SQL SELECT DISTINCT | Database Solutions for Microsoft Access | databasedev.co.uk
![sql - MS Access Count unique values of one table appearing in second table which is related to a third table - Stack Overflow sql - MS Access Count unique values of one table appearing in second table which is related to a third table - Stack Overflow](https://i.stack.imgur.com/L9YFB.png)
sql - MS Access Count unique values of one table appearing in second table which is related to a third table - Stack Overflow
![ms access - can anyone figure out how to get a query to return a count of distinct records? - Stack Overflow ms access - can anyone figure out how to get a query to return a count of distinct records? - Stack Overflow](https://i.stack.imgur.com/mv5ak.jpg)