Concatenate FirstName and LastName field and include a space

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 12 Nov 2007 00:12 GMT

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,

Signature

Chuck W

Reply to this Message

Douglas J. Steele - 12 Nov 2007 00:19 GMT

[FirstName] & " " & [LastName]

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi,
> I have a FirstName and LastName field. I want to concatenate the two
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message

sheniece - 12 Nov 2007 00:28 GMT

>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]

Reply to this Message