How do I get rid of Duplicated data?

[tahoskier]

I have a table with thousands of records with mailing info. Half the records are dependents with the same mailing info. How can I get rid of the extra household member records? I would like to keep only one record per household. It does not matter which one.

Thanks

 

[r937]

select distinct column1, column2, column3
into newtable
from oldtable

will create a second table without duplicates in the columns selected

rudy

 

[scriverb]

Check out this thread: thread705-376298

I just answered this question with an answer that can be modified to meet your needs.

Let me know if you need any help modifying the queries. Bob Scriver