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

[Guest]

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

 

[Joseph Meehan]

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]"

You could do it using an update query, but don't. You don't want to
duplicate data. Not only because Access would rather just make it up when
needed, but consider if Joe decides he wants to be Joseph and someone
forgets to fix the combined field. Bad idea.