How do you concatenate collumns or fields in a Query?

[Guest]

I know how to concatenate cells in excel, but how to I put text together from two Access fields or even collumns

E
Customer First Name Customer last name Combine
Jo Blow Jo Blow

 

[Rick B]

In a new column in the query enter...

CombinedName: [CustomerFirstName] & " " & [CustomerLastName]


RickB


I know how to concatenate cells in excel, but how to I put text together
from two Access fields or even collumns?

Ex
Customer First Name Customer last name Combined
Jo Blow
Jo Blow