Sum two text fields and get a space between

[carolineJ]

Hi, this has probably been up hundred of times already. I have tried to search the forum for an answer for about half an hour now without any result (probably because I express myself different than someone with English as their native language)

So sorry for posting this simple question:

I have a table with the fields "First name" and "Last name". In my query I got the field Name, which of course is [First name] + [Last name]. However if we got for example the name Caroline Jones, in the query it looks like CarolineJones. How do I get a space between?

 

[CosmoKramer]

[First name] & " " & [Last name]

 

[Sawatzky]

dear caroline,

[First name] & " " & [Last name]

regards Astrid

 

[carolineJ]

Ah thanks, I would never have figured it out myself