Mailing labels

[dougjrs]

I have a table that has a list of people that I would like to do a
mailing to. The table has the fields First Name, Last Name, House
number, Street name, City, State, ZipCode. What I would like to do is
elimate sending 2 or 3 pieces of mail to the same address. I would
like to have some kind of query that would allow me to identify same
last name, House, Street Name and create one label with Last Name
"Family".

I know how to print the labels, what I dont know if how to take
multiple rows and create one row that has the Last Name and then the
work "Family".

Any one know how to do this?

Thanks,
Doug

[Ed Robichaud]

I'll ignore that you don't have a unique/primary key for your table and have
duplicate and non-normalized records, so suggest that you use a "totals"
query and "Group By" [house#] and [streetname] to get one record per
address. Use the Labels report wizard to setup your labels. The first line
of your label should be an unbound text box with the control source of:

=Trim([Lastname]&" "&"Family" OR ="The"&"
"&Trim([Lastname]&" "&"Family"

-Ed

<do*****@kc.rr.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

I have a table that has a list of people that I would like to do a
mailing to. The table has the fields First Name, Last Name, House
number, Street name, City, State, ZipCode. What I would like to do is
elimate sending 2 or 3 pieces of mail to the same address. I would
like to have some kind of query that would allow me to identify same
last name, House, Street Name and create one label with Last Name
"Family".

I know how to print the labels, what I dont know if how to take
multiple rows and create one row that has the Last Name and then the
work "Family".

Any one know how to do this?

Thanks,
Doug

[Phil Stanton]

Just as a starting thought. I have a number of databases and tend to hold
the Address in 1 table and the names in another table with a foreign key to
AddressID. This allows me to print to Mr & Mrs Smith or A Smith & Family
etc. Prevents problems with slightly different versions of the Address, and
means you only have to type the address once.

Equally, as many of the members in my Club database are local, I hold the
City in another table and State (County) in another table with a StateID as
a foreign key in the City Table and the CityID as a FK in the Address table.
Then I select the City, and the State is automatically inserted. Only useful
if there are a number of duplicates in the City

HTH

Phil
<do*****@kc.rr.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

I have a table that has a list of people that I would like to do a
mailing to. The table has the fields First Name, Last Name, House
number, Street name, City, State, ZipCode. What I would like to do is
elimate sending 2 or 3 pieces of mail to the same address. I would
like to have some kind of query that would allow me to identify same
last name, House, Street Name and create one label with Last Name
"Family".

I know how to print the labels, what I dont know if how to take
multiple rows and create one row that has the Last Name and then the
work "Family".

Any one know how to do this?

Thanks,
Doug