Help with a conditional duplicates Query

[ddean1968]

Ok I want to thank you in advance, since this may or may not make a ton of sense.

I am working with a databse that is riddled with dupes. However not all can be deleted, that's relatively normal of course. The tricky part I need a sssistance with is this.

Lets say that there are 3 dupes found for one set of conditions. I need to find a way to test the groups of dupes for a condition. Lets Say Field 10 has 3 possible values. A - B - C , I need the Query to be able to test the group and then create another table that can have the duplicates safe to remove have the key field value input into it.

So if there is a group of 3, it will test field 10's value if it is an "A" it will not consider that record for deletion, wether it is a duplicate or not. However if one is and "A" and the rest are B or C it will append this information to a secondary table. Furthermore if there is no "A" then the "B" would be the record we wanted to save from being deleted.

I have never before had to tackle a query such as this and would appreciate any assistance.

 

[Elysium]

Can you explain this with real data? It's a little hard to follow.


Randy