Re: Concatenate FirstName and LastName field and include a space

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
Date: Sun, 11 Nov 2007 19:19:19 -0500

[FirstName] & " " & [LastName]

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

"ChuckW" <haji@xxxxxxxxxxx> wrote in message
news:661A017A-A91C-401E-BEB9-06536374A16A@xxxxxxxxxxxxxxxx

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,
--
Chuck W

Prev by Date: Re: run a quety without a warning
Next by Date: Re: Concatenate FirstName and LastName field and include a space
Previous by thread: Re: run a quety without a warning
Next by thread: Re: Concatenate FirstName and LastName field and include a space
Index(es):
- Date
- Thread

Relevant Pages

Re: I just installed Office 2003...
... "Douglas J. Steele" wrote: ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ...
(microsoft.public.access.setupconfig)
Re: Multi-Select list box on a Data Entry Form
... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... I have multiple forms that the users can go to that displays ...
(microsoft.public.access.forms)
Re: Help with Microsoft help on linking Access to Outlook
... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... Set MyRS = MyDB.OpenRecordset ...
(microsoft.public.access.formscoding)
Re: ignoring format/control codes exporting data from access to ex
... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... If you're using it in a query, open the query in Design view, then select ...
(microsoft.public.access.externaldata)
Re: A date function in Access using VB
... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... persons age and weight. ...
(microsoft.public.access.formscoding)