label printing

[woodensails]

I have a table with multi objects among which are surname and spouse. This
is part of a membership list, I would like to print membership cards for
member and spouse. No problem doing separate runs, but would like to print
all in one run. Suggestions please
Lyn

[lesperancer]

assuming you have a query for members and a query for spouses, create
another query using UNION

SELECT * FROM qryMember
UNION
SELECT * FROM qrySpouse

[Allen Browne]

You need some way to define which persons are members of the same household,
so you can direct the mailing to the household rather than the individual
members.

For one approach, see:
People in households and companies
at:
http://allenbrowne.com/AppHuman.html
It includes a downloadable example (Access 2000 and later.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"woodensails" <ly******@ns.sympatico.ca> wrote in message
news:VL********************@ursa-nb00s0.nbnet.nb.ca...

I have a table with multi objects among which are surname and spouse. This
is part of a membership list, I would like to print membership cards for
member and spouse. No problem doing separate runs, but would like to print
all in one run. Suggestions please
Lyn