G Guest Feb 23, 2005 #1 If not, how I can put in one column the name an lastname of my employees that are in separated columns
If not, how I can put in one column the name an lastname of my employees that are in separated columns
J JP Feb 23, 2005 #2 The & or the + operator when used on strings serves as a concatenator. For example, field lname has last name, field fname has first name, then fullname = fname & " " & lname will concatenate the first name and last name with a space between them. Similarly, fullname = lname & ", " & fname will put them in last name, first name form.
The & or the + operator when used on strings serves as a concatenator. For example, field lname has last name, field fname has first name, then fullname = fname & " " & lname will concatenate the first name and last name with a space between them. Similarly, fullname = lname & ", " & fname will put them in last name, first name form.
