What is the best way to calculate unique distinct records for multiple columns in Access queries.
I tried :
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_NameACode:SELECT DISTINCT Column_NameA FROM Table_Name;
Any suggestions?
Thanks in advance