Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Mailing List, need in December

Mailing List, need in December

Mailing List, need in December

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.

RE: Mailing List, need in December

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

RE: Mailing List, need in December

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.

RE: Mailing List, need in December

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.

RE: Mailing List, need in December

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

RE: Mailing List, need in December

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close