How do you concatenate collumns or fields in a Query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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