Delete Duplicate Records

[NeonSky via AccessMonster.com]

Hello All!

I have record "A" and record "B" in table "Zoo". Record "A" and record "B"
are exactly the same. I would like to delete record "A" and keep record "B".

Happy to provide additional info.

As always thanks very much!

 

[Jeff Boyce]

First, if they are truly "exactly the same", why have you chosen "B"? Would
it be enough to get rid of ONE of them?

One approach would be to create a query that returns all the fields, then
modify the query's UniqueValues property to Yes. This should return one of
each unique records.

You could then append these unique records to a new table.

The downside/risk is that you could lose the connection to any related
("child") records...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[NeonSky via AccessMonster.com]

Thanks for getting the wheels turning Jeff, I have since figured out how to
accomplish what I set out to do. Though your approach is very interesting and
I will keep it in mind in the future. Thanks!

First, if they are truly "exactly the same", why have you chosen "B"? Would
it be enough to get rid of ONE of them?

One approach would be to create a query that returns all the fields, then
modify the query's UniqueValues property to Yes. This should return one of
each unique records.

You could then append these unique records to a new table.

The downside/risk is that you could lose the connection to any related
("child") records...

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello All!

[quoted text clipped - 5 lines]

As always thanks very much!