Sorry. Dealing with thousands of records and a few to several hundred are duplicates so TOP 1 wouldn't work.

The only thing I can come up with so far seems too complicated as I tend to overcomplicated things.