Select Distinct Question

[Guest]

I have a select distinct query that provides

CustomerID
Address
City
State
Zip

I need to add the Customer Name to the distinct list I created but here is
the problem. This individual rows that roll up to make a distinct records
may contain variations in the Customer Name thus creating duplicates. I
guess Access as to have a distinct RECORD as opposed to a distinct field.
Which Customer Name that get added to the list doesn't matter to me.

How do I create a query that will just use the first Customer name it
encounters when I link on CustomerID

 

[David Cox]

use group by instead of distinct and select first instead of group by for
the name field in the QBE grid..