Update Query Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try this:
[Main Gant Database].[Title] + " " & [Main Gant Database].[Firstname] +
" " &
[Main Gant Database].[Additional Fname] + " " & [Main Gant
Database].[Surname]
 
Back
Top