Mailing List, need in December 1

[SoClueless]

I am trying to avoid sending duplicate newsletters to families on our mailing list. Our list consists of over 1600 children, several of whom are siblings. I would like to know how to pull records for mailing label report so that only one record per family appears on mailing labels. Have been trying to think of how to do this for so long, maybe a simple answer, but I cant figure it out. Would appreciate help soon as it is end of november and newsletter has to go out in december. Thank you so much.

 

[repete]

seems like what you are looking for is a method to establish where more than one record are duplicates because of the 'same family' test. what rules you apply to the 'same family' test will depend on your data (eg same surname ? same surname at same address ?) and how complex your data is

without regard to syntax, "select surname from yourfile" will give you all members of the family, whilst "select distinct surname from yourfile" will give you one member (if your family test is on surname)

hope this sends you in the right direction Pete Bloomfield
Down Under

 

[SoClueless]

Thank you, Pete. I am going to try to follow your advice, tho I am a novice at this aspect of the database, and see what happens. I'll let you know.

 

[SoClueless]

Help! This is an Access db and I'm not sure where to put that statement. I would be looking to pull only one person with the same last name at the same address. Thank you.

 

[repete]

I don't use Access, so I would only be muddling in trying to help you. Try posting your question in one of the following forums, and remember to add the version of Access that you are using, so people can understand the interface you have, and how then best to help you.


Microsoft: Access - General discussion
Microsoft: Access Forms
Microsoft: Access Modules (VBA Coding)
Microsoft: Access Queries and Access/SQL
Microsoft: Access Reports
Microsoft: Access Tables and Relationships


Good luck
Pete Bloomfield
Down Under

 

[Catwoman]

Pete,
Thank you so above info,; it helped me too!