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

Oops, seems like it's my third attempt to help on the problem, which is not clearly defined. Therefore - no stars again :( :)