One Label for Each Address, adding "Family" Name

[LoriM]

I'm using Access 2007 where I have a database with 575 karate students (with
a lot of siblings). Each student is on a separate record.

I want to create mailing labels but here's where I get stuck.

(1) Only one label to each address
(2) Instead of full name I would like it to say "The Smith Family"
(3) In today's age, some households have multiple last names. Not sure how
to handle that, possibly "The Smith & Jones Families".

Fields that I will be using for this are:
First Name, Last Name, Address, City, State, Postal Code

I greatly appreciate any suggestions/insight that you are able to provide!

 

[Allen Browne]

Lori, there's not a simple way to automatically handle all the combinations
of name, or even to automatically identify which people at an address should
be combined into a single mailing, let alone the people who should be in a
mailing (remembering you must provide opt-out choices.)

The best solution is therefore to identify the groupings that form
"households", and the records that form a mailing list.

Download this sample database that illustrates one way to create that kind
of data structure:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

 

[LoriM]

Thank you so much for your reply, Allen. I can see I have a bit of reading &
learning about relationships today!