add a new field that combines firt and last name

J

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

Fred Boer

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
 
Top