Concatenate FirstName and LastName field and include a space

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

Guest

Hi,
I have a FirstName and LastName field. I want to concatenate the two fields
but when I do there is no space between the first and last names which is
what I want. Can someone help?

Thanks,
 
ChuckW said:
Hi,
I have a FirstName and LastName field. I want to concatenate the two fields
but when I do there is no space between the first and last names which is
what I want. Can someone help?

Thanks,
Click to expand...


are you concatenateing in a query? if you are try this
Name: [FirstName] & " " & [LastName]
 
Back
Top