This should be easy, but I just can't get it to work right.
I have a table that contains records with duplicate phone numbers (data supplied by client). I only want one record per phone number.
I can delete duplicates by a hierarchy ranking, but some have the same rank. So next I delete based on keeping the most recent date. Ok, but there are still some duplicates with the same date. At this point, I figure I can just delete based on their autonumber ID field - doesn't matter if I keep the highest or lowest, so long as I'm left with just one.
This is what I can't get. I'd post some attempts, but not at work now. The odd thing is, if I filter the table by phone number at this point, I get only one record. Ok, that might throw an error. But if a run a find duplicates query based on an Access wizard, I get 406 records (not all same phone, but at least two for any individual number).
Any ideas? Thanks.