How do you concatenate collumns or fields in a Query?

B

BrettBum

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
 
R

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
 
Top