How do I have multiple first names in address labels

[Guest]

I need to have "Frank and Sue Smith" on my address labels. I can't figure
out how to list two FirstName fields on the same label. If I need to change
the table designs, etc... I'm willing to do that, but I don't know how to set
up the query or report to make this work. Thanks.

 

[Rick B]

Before we can tell you how to create the labels, we would need to know how
your data is structuredd. Assuming you have a Name and a Spouse name, your
unbound field would look something like...


[FirstName] & (" "+[SpouseName]) & " " &[LastName]





Rick B

 

[Rick B]

OOPS!

Make that...

[FirstName] & (" and "+[SpouseName]) & " " &[LastName]

Before we can tell you how to create the labels, we would need to know how
your data is structuredd. Assuming you have a Name and a Spouse name, your
unbound field would look something like...


[FirstName] & (" "+[SpouseName]) & " " &[LastName]





Rick B

I need to have "Frank and Sue Smith" on my address labels. I can't figure
out how to list two FirstName fields on the same label. If I need to change
the table designs, etc... I'm willing to do that, but I don't know how

to

set
up the query or report to make this work. Thanks.

 

[Guest]

Each individual is a separate record (this is a church database) and the
address information is applied to the individuals by the link of FamilyID and
FamilyLastName. So, we have a Families Table that holds all shared info,
address, phone, last name, etc and an Individual Table which holds personal
info such as, cell phone, birthday, etc. The relationship join is the
FamilyID (first 4 letters of last name followed by a 2-digit number). Thanks

OOPS!

Make that...

[FirstName] & (" and "+[SpouseName]) & " " &[LastName]

Before we can tell you how to create the labels, we would need to know how
your data is structuredd. Assuming you have a Name and a Spouse name, your
unbound field would look something like...


[FirstName] & (" "+[SpouseName]) & " " &[LastName]





Rick B

I need to have "Frank and Sue Smith" on my address labels. I can't figure
out how to list two FirstName fields on the same label. If I need to change
the table designs, etc... I'm willing to do that, but I don't know how

to

set
up the query or report to make this work. Thanks.

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP
--

Each individual is a separate record (this is a church database) and the
address information is applied to the individuals by the link of FamilyID
and
FamilyLastName. So, we have a Families Table that holds all shared info,
address, phone, last name, etc and an Individual Table which holds
personal
info such as, cell phone, birthday, etc. The relationship join is the
FamilyID (first 4 letters of last name followed by a 2-digit number).
Thanks

OOPS!

Make that...

[FirstName] & (" and "+[SpouseName]) & " " &[LastName]

Before we can tell you how to create the labels, we would need to know
how
your data is structuredd. Assuming you have a Name and a Spouse name, your
unbound field would look something like...


[FirstName] & (" "+[SpouseName]) & " " &[LastName]





Rick B




I need to have "Frank and Sue Smith" on my address labels. I can't figure
out how to list two FirstName fields on the same label. If I need to
change
the table designs, etc... I'm willing to do that, but I don't know
how to
set
up the query or report to make this work. Thanks.