Is there any way of doing this. I know you can use SELECT DISTINCT to not havce multiple records, which I have done in my query, but I want to also removed doubles that the same exact address and email field as others.. Any help would be great. 
Oh, and If possible could I also add a couple more fields for person 1/2/3 etc, and add the other names with the same address/email to that record in the query, instead of them all being seperate?
Oh, and If possible could I also add a couple more fields for person 1/2/3 etc, and add the other names with the same address/email to that record in the query, instead of them all being seperate?
