How to eliminate rows with redundant values and keep other values?

  • Thread starter Thread starter gordy
  • Start date Start date
G

gordy

I have a spreadsheet with 64000 lines/28 columns describing potential
customers within several counties (coded). There are multiple customer names
because they do business in multiple counties. I could just break-out
everything by county, but then I'd be contacting the same customers several
times.
Is there a way to reduce the dataset to unique customer names with only one
county code while maintaining the association of these people with the values
in all the other columns?
 
SELECT customer, LAST(county), LAST(phoneNumber), LAST( whatever)
FROM tableName
GROUP BY customer



Vanderghast, Access MVP
 
Back
Top