Duplicate records in a mailing list?

[Guest]

How do i remove duplicate records form a mail list? I have a list of 600
names and find many duplicates. I attempted to use the 411 from HELP but
still get strange null key errors.

 

[gls858]

How do i remove duplicate records form a mail list? I have a list of 600
names and find many duplicates. I attempted to use the 411 from HELP but
still get strange null key errors.

go to queries, new, and from the box select find duplicate query wizard.
Follow the prompts it's pretty straight forward.

gls858

 

[Guest]

Thanks. Will this also allow me to remove the duplicates? At the current
postage rate any dupes cost me too much to not clean the list.

 

[gls858]

Thanks. Will this also allow me to remove the duplicates? At the current
postage rate any dupes cost me too much to not clean the list.

:

When the query results are returned you should be able to highlight the
records right click and select delete. I would suggest you take a backup
copy of the db before doing this just in case. Always nice to have a safety
net.

gls858

 

[Guest]

Thanks I will try this method out! I do not work in Access to often so I
always work on a copy.

 

[Guest]

A simple way is to make a copy of the table's structure under a new name,
which you can do by copying and pasting the table in the database window.
Decide what combination of fields should be unique in the table, e.g. it
might be Firstname, LastName and AddressLine1. In the empty table make them
its primary key in design view by selecting the fields (use Ctrl-Click just
as you would when selecting multiple files in a folder), and then right click
and select primary key from the shortcut menu.

If you now create an Append query to append all rows from your existing
table to the empty one, when you run this query only one of each row where
the primary key values are the same will be appended. You'll get a message
telling you how any will be rejected.

Once you are satisfied that the new table holds the correct records you can
delete the original one and rename the new one to the name of the original.

 

[Guest]

Thanks! I will try this too!

A simple way is to make a copy of the table's structure under a new name,
which you can do by copying and pasting the table in the database window.
Decide what combination of fields should be unique in the table, e.g. it
might be Firstname, LastName and AddressLine1. In the empty table make them
its primary key in design view by selecting the fields (use Ctrl-Click just
as you would when selecting multiple files in a folder), and then right click
and select primary key from the shortcut menu.

If you now create an Append query to append all rows from your existing
table to the empty one, when you run this query only one of each row where
the primary key values are the same will be appended. You'll get a message
telling you how any will be rejected.

Once you are satisfied that the new table holds the correct records you can
delete the original one and rename the new one to the name of the original.