add a new field that combine first and last name in access

[Jay]

I have customer table with a first name and a last name, respectively
I want to add a new field that comebines a first and last name to make a
full name.
I don't know know where shoud I put "[userlastname]&", "&[userfirstname]"

 

[Larry Linson]

I have customer table with a first name and a last name, respectively
I want to add a new field that comebines a first and last name to make a
full name.
I don't know know where shoud I put "[userlastname]&", "&[userfirstname]"

There's no need to duplicate information in a Table if that information can
be calculated from information in the Record when it is needed to be used.
And, in fact, it is poor practice to do so. Put your expression in the
Queries that you use to retrieve the information for Forms and Reports.

Larry Linson
Microsoft Access MVP