Query - No duplicate records

[Guest]

I have a join query that has duplicate customer names. I only want the
customer name to appear once. Is there a way to easily do this?

Thanks in advance.

 

[Douglas J. Steele]

It depends on what the values of the other fields are.

Access supports two different DISTINCT clauses in SQL statements: SELECT
DISTINCT and SELECT DISTINCTROW.

SELECT DISTINCT Field1, Field2, Field3

will eliminate duplicates where Field1, Field2 and Field3 are the same.

SELECT DISTINCTROW Field1, Field2, Field3

will only eliminate duplicates of Field1, Field2 and Field3 if all the other
fields in the table are also duplicated. (To be honest, I've never really
seen the point of SELECT DISTINCTROW!)