Update Query Formatting

[Guest]

I am running an update query where I am updating one field in a table with
the contents of 3 fields from the same table. The query works fine but it
updates the reslts with no spaces between each value - so the query critieria
is this

[Main Gant Database].[Title] & [Main Gant Database].[Firstname] & [Main Gant
Database].[Additional Fname] & [Main Gant Database].[Surname]

And the result is

MRIAINRICHARDGIBBONS and I want it to be MR IAIN RICHARD GIBBONS

 

[Allen Browne]

Try this:
[Main Gant Database].[Title] + " " & [Main Gant Database].[Firstname] +
" " &
[Main Gant Database].[Additional Fname] + " " & [Main Gant
Database].[Surname]