Delete Duplicate Records

  • Thread starter NeonSky via AccessMonster.com
  • Start date
N

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!
 
J

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
 
N

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!
Jeff said:
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!
Click to expand...
[quoted text clipped - 5 lines]
As always thanks very much!
Click to expand...
Click to expand...
 
Top