If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Name tags
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. Any help would be appreciated. Thanks, -- Phil |
#2
|
|||
|
|||
Name tags
Hi Phil,
select [First-Name] & " " & [Last-Name] as PersonName, iif(isnull([Spouse-Name]), "No Spouse", [Spouse-Name] & " " & [Last-Name]) as SpouseName from TABLENAME Hope this helps. Damian. "Phil" wrote: 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. Any help would be appreciated. Thanks, -- Phil |
#3
|
|||
|
|||
Name tags
"Phil" wrote in message ... 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 |
#4
|
|||
|
|||
Name tags
Thanks Larry,
What you gave me was just what I needed...... I works great. -- Phil "Larry Linson" wrote: "Phil" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|