Concatenate FirstName and LastName field and include a space

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,
 
S

sheniece via AccessMonster.com

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,


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top