Hi Guys, Could you help me please? I have a table with three columns. 1. RefNum 2. Salutation 3.Email Address I want to pull out of the single table all the records with a unique email address. so if there are 4 records with the same email I want just 1 of the 4 records with that email address and the others to be deleted. If there is only 1 occurance of an email address pull that out also. Thanks for your help, I appreciate it. Best Regards, Steve.