Removed duplicates before an export

[snipe]

Hey guys,



I have a query that pulls from master table of customers. All of these records are entered by the office staff. Currently, we clean up the records (capitalization, trimming, etc) and then export to our printer to have mailings sent out to them. We don't have anything that removes the duplicates.

The catch is the "duplicates" won't be exact duplicates. ID (auto number), Salesperson, Store, and Type will probably be different.

What is the best way to remove the dupes? I want to primarily remove based of same first name, last name, and first 3 characters of address.

[snipe]

Got it. Nvm!

http://allenbrowne.com/subquery-01.html#DeDuplicate

[lfpm062010]

This will do what you need but if you need changes then you need to be more specific what you are trying to do.

Using the GROUP BY (Auto Sum symbol in design view) on column Fname, LName, and LEFT(ADDRESS, 3). Then use FIRST for rest of the column.