add a new field that combines firt and last name

  • 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]"
 
Dear Jay:

You probably wouldn't want to put a new field in a table to hold that
information, since that would duplicate data, which is a no-no. Instead, you
would create a query and use the construction you give as an expression.
Base your form on this query.

Good luck!
Fred Boer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add a new field that combine first and last name in access 2
Linking First and Last Names 4
Use combined name on form 7
VBA - retrieve data on last create named range from previous inserted named range 0
How do I combine "First Name", "Last Name" Fields into a "Name" Fi 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
combining two or more table fields into a single table field 1
How do I concatenates two fields into one field in the same table? 3

Back
Top