Unique distinct records for multiple columns

[sk88]

What is the best way to calculate unique distinct records for multiple columns in Access queries.



I tried :

SELECT DISTINCT Column_NameA FROM Table_Name;

That works perfectly fine. But what if I have multiple columns that I would like to see but the distinct should be based on Column_NameA

Any suggestions?

Thanks in advance

[JoeM]

One way is to use Aggregate Queries, in which you "Group" all like records together (to weed out duplicates) based on any number of fields you want.

That might look something like this (which "Groups By" three fields):

SELECT Field1, Field2, Field3
FROM Table_Name
GROUP BY Field1, Field2, Field3;