Sorry if the problem was not defined clearly. I do want records with no duplicates too. And the ones with duplicates, I want the 1st record only. Thank you for all your help!!!! I'm amazed at what you can do with SQL statement & you certainly know how to use it to the max! Thanks for sharing!!!!!