Phil said:
Hi,
I have and Access 2000 table that has (among other things) Last-Name,
First-name, and spouse-name. I would like to print name tags from this
table. What I need are labels for everyone in the table. Is it possible
to
print two labels for each record in the table, one with
First-name/Last-Name
and one with spouse-name/Last-Name? The other kicker is that there is not
always a spouse.
How you would go about creating the report would depend on how your name tag
label sheets are sized and laid out. One simple way would be to create two
Queries, one for the main entry and one for the spouse name, then use UNION
ALL to join them.
For a People Table with Fields LastName, FirstName, and SpouseName (just in
case there's a duplicate, you might want to add an AutoNumber field for
Record ID), you can create two queries, each with a FullName calculated
field (qryNameTagsPeople: FullName: [FirstName] & " " & [LastName] and
qryNameTagsSpouses FullName: [SpouseName] & " " & [LastName]), a LastName
field (both: [LastName]), a FirstName field (qryNameTagsPeople: [FirstName]
and qryNameTagsSpouses, a calculated Field FirstName: [SpouseName], with a
Criteria for SpouseName of Not Null) then create a Query qryNameTagsUnion
with SQL of
SELECT * From qryNameTagsPeople
UNION ALL
SELECT * From qryNameTagsSpouses
ORDER BY LastName,FirstName;
Use this, or a modification/enhancement with additional information from
your table, as the RecordSource for your NameTags. For Avery Labels, and
others with the same dimensions, Avery has templates on their website,
identified by Avery label number, that you can download. If you are using a
commercial name tag paper product to print your name tags, there's a good
chance you will find an Avery template. You can eithe go directly to the
Avery website,
http://www.avery.com/, or if you happen to be browsing the
Microsoft Office Online site,
http://office.microsoft.com, you'll find a
link.
Larry Linson
Microsoft Access MVP
