removing duplicate records from a table?

[mcl]

I've used the find duplicates wizard and yes, it shows me the records with
duplicates but I need all but one of each removed. It doesn't make a
difference which record is kept from a chronological order point of view,
but I just need one of each kept. How do I do that?

 

[Jeff Boyce]

One approach would be to create a new table with an identical structure,
create a query that returns unique rows (see the query's properties), and
append the unique rows (less any ID) to the new table.

Now the bad news ... if this is a "parent" table, you'd need to first manage
the "child" records, which would be pointing back to potentially missing
parentIDs.

Regards

Jeff Boyce
<Access MVP>

 

[Michel Walsh]

Hi,


Either append all records in a new table that does not allow duplicated
values (there will be an error that some records have not been appended, but
that is exactly what you want),


either:


SELECT f1, LAST(f2), LAST(f3), ... , LAST(fn)
FROM myTable
GROUP BY f1



Hoping it may help,
Vanderghast, Access MVP