Select Update and Export Unique Values

  • Thread starter Thread starter Craig Ferrier
  • Start date Start date
C

Craig Ferrier

I have a database of 17000 names and addresses. I want to extract each
individual unique address (11000 Items) to another file so I can forward it
to a mailhouse whereby we can mail 1 item per household.

How can I do this?

Craig
 
You could create a query based on the table and click the
sigma (Totals) button on the toolbar to show a line for
summary options. Under each of the Address fields
choose "Group By". If you want to filter out multiple
names for one address, you will have to decide which name
to include (such as Max). When you view the query you
will see each unique Address and the selected name.

Then, there are multiple ways to export import. One way
would be to create a new blank database, choose File|Get
External Data|Import and select the database that your
query is in. Then go to queries and select your query,
but before clicking OK click the options button and
choose to import the query as a table.

HTH

-Ted Allen
 
Back
Top