Exists a function such as excel's =concatenate() in acces???

F

filo666

If not, how I can put in one column the name an lastname of my employees that
are in separated columns
 
J

JP

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