I hope you can help share some light on my problem.
Basically, I have a MS Access table...ID, firstname, surname, Address1, Address2 etc
What I want to do is Select all from table but only show one record where more than one person lives at that address .. Eg only sending one envelope to the one household rather than sending two to the same address ....
I wouldnt have thought it was overly complex, however the combinations that I have been trying from the query builder havent worked ..
I can get a count of the number of records where the same address exists but I can't display a first name aswell.
Your suggestions will be greatly welcomed ... Thanks