2 different fields to make one additional field

[Guest]

Hi! I'm still pretty much a beginner when it comes to Access but have
managed so far. *Grin*

I'm trying to take the "First" name field and the "Last" name field and put
them together in a third field called "Display Name". I don't want to keep
typing the Display Name when I don't have to.

For example, the name Jane Doe.

First Last Display Name
Jane Doe Jane Doe

Does anyone know how I can do this?

Thanks in advance!
Chris

 

[tina]

saving calculated data (first name + last name) in a table is a violation of
data normalization rules, and also not necessary. you have the atomic data
elements (first name, last name) saved in separate fields in your table -
this does follow data normalization rules. you can display the "full" name
whenever and wherever you need to by concatenating those two fields in a
query, as

FullName: FirstName & " " & LastName

or in the ControlSource property of an unbound control in a form or report,
as

= [FirstName] & " " & [LastName]

hth

Hi! I'm still pretty much a beginner when it comes to Access but have
managed so far. *Grin*

I'm trying to take the "First" name field and the "Last" name field and put
them together in a third field called "Display Name". I don't want to keep
typing the Display Name when I don't have to.

For example, the name Jane Doe.

First Last Display Name
Jane Doe Jane Doe

Does anyone know how I can do this?

Thanks in advance!
Chris

http://rwlima.referralware.com

 

[Guest]

Thanks Tina for responding so quickly.

I'm trying to use Access to help with the mail merge feature in Outlook. Do
you know if that can be done during the mail merge? Will I be able to put
the persons full name on the email by doing what you said?

Chris
--
Do people really make money on the internet? http://rwlima.referralware.com

saving calculated data (first name + last name) in a table is a violation of
data normalization rules, and also not necessary. you have the atomic data
elements (first name, last name) saved in separate fields in your table -
this does follow data normalization rules. you can display the "full" name
whenever and wherever you need to by concatenating those two fields in a
query, as

FullName: FirstName & " " & LastName

or in the ControlSource property of an unbound control in a form or report,
as

= [FirstName] & " " & [LastName]

hth

Hi! I'm still pretty much a beginner when it comes to Access but have
managed so far. *Grin*

I'm trying to take the "First" name field and the "Last" name field and put
them together in a third field called "Display Name". I don't want to keep
typing the Display Name when I don't have to.

For example, the name Jane Doe.

First Last Display Name
Jane Doe Jane Doe

Does anyone know how I can do this?

Thanks in advance!
Chris

http://rwlima.referralware.com

 

[tina]

in whatever source you're using for the mail merge (a query?), substitute
the calculated value of "full name", as noted in my previous post, in place
of a single field.

hth

Thanks Tina for responding so quickly.

I'm trying to use Access to help with the mail merge feature in Outlook. Do
you know if that can be done during the mail merge? Will I be able to put
the persons full name on the email by doing what you said?

Chris
--
Do people really make money on the internet? http://rwlima.referralware.com

saving calculated data (first name + last name) in a table is a violation of
data normalization rules, and also not necessary. you have the atomic data
elements (first name, last name) saved in separate fields in your table -
this does follow data normalization rules. you can display the "full" name
whenever and wherever you need to by concatenating those two fields in a
query, as

FullName: FirstName & " " & LastName

or in the ControlSource property of an unbound control in a form or report,
as

= [FirstName] & " " & [LastName]

hth

Hi! I'm still pretty much a beginner when it comes to Access but have
managed so far. *Grin*

I'm trying to take the "First" name field and the "Last" name field

and
put

them together in a third field called "Display Name". I don't want to keep
typing the Display Name when I don't have to.

For example, the name Jane Doe.

First Last Display Name
Jane Doe Jane Doe

Does anyone know how I can do this?

Thanks in advance!
Chris

http://rwlima.referralware.com