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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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]"
 
Jay said:
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]"
Click to expand...

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
 
Jay said:
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]"
Click to expand...

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.
 
Back
Top