Combining data in a table/field

[DV]

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.

 

[dalaw]

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.