Combining data in a table/field

[Guest]

Can I combine data from 2 different fields into a new field? For example,
and I combine the text fields LAST_NAME and FIRST_NAME into a new field
called EMPLOYEE NAME automatically each time information is entered into the
first 2 fields.

 

[Joseph Meehan]

Can I combine data from 2 different fields into a new field? For
example, and I combine the text fields LAST_NAME and FIRST_NAME into
a new field called EMPLOYEE NAME automatically each time information
is entered into the first 2 fields.

I would not recommend that. Rather than store all that data, why not
create a query and have a dynamic EMPLOYEE NAME field. That would be
[LAST_NAME]&" "&FIRST_NAME] Access will like that better and in the even
you some woman marries and changes that last name you will not have your
data out of sync.

 

[Guest]

Yes, in a query

flnme: [fnane]+" "+[lname]

 

[Douglas J Steele]

I'd recommend using &, not +.

If either [fname] or [lname] are Null, [fnane]+" "+[lname] will result in a
Null value, even if the other value isn't Null.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Yes, in a query

flnme: [fnane]+" "+[lname]

Can I combine data from 2 different fields into a new field? For example,
and I combine the text fields LAST_NAME and FIRST_NAME into a new field
called EMPLOYEE NAME automatically each time information is entered into the
first 2 fields.