Combining data in cells with with a space

[elfeste]

I am trying to combine a first and last name from a table for use in
report.

First name John
Last name Doe

I need the report to display John Doe with the space in between
What I get is JohnDoe

I am using the expression =[FirstName] & [LastName] to produce th
result in the report.

Does anyone know what I need to do to display the name with the space?

Thank

 

[Gilligan]

FirstName & " " & LastName

I am trying to combine a first and last name from a table for use in a
report.

First name John
Last name Doe

I need the report to display John Doe with the space in between
What I get is JohnDoe

I am using the expression =[FirstName] & [LastName] to produce the
result in the report.

Does anyone know what I need to do to display the name with the space?

Thanks