Combining two cells

[Chum]

In a query design view, I have two fields, LastName and FirstName. In the Field of a blank column I enter [LastName]&[FirstName]. In the query the last and first names are now connected , like SmithJohn. How do I put a space and or a comma to separate them?

 

[chergh]

Try:

[LastName] & " " & [FirstName] for a space between them

or

[LastName] & ", " & [FirstName] for a comma and a space