query to eliminate duplicate records

[Joseph Schwartz]

I have an access table with the following structure:

Name Phone Extension

over time I have added duplicate records to the table and I would like to
run a query to eliminate all of the duplicate records.

How would I go about doing that?

any help appreciated.

Joe

 

[Howard Brody]

Try a query using Totals and select GroupBy for each
field. The results will show each unique record and you
can append them into a new table.

A couple places you might have problems are:

if different people were given the same extention at

different times (they'll all show up as you don't have a
field to denote which is the current person at the
extention)

if the same person was entered with their name spelled

differently - ie Mike Johnson and Michael Johnson.

My recommendation is to run the GroupBy query and dump
them into a new table. Then go through and make any other
changes (or deletions) you need to using code (if you can)
or manualy (if you can't).

Hope this helps!

Howard Brody