Concatenation with spaces

[Suidae]

I have an Update statement which is working just fine but what I need are spaces between the joined fields. Robert Jones is showing as RobertJones.

    sql = "UPDATE tbltmpMobileS, tbldefEIC SET tbltmpMobileS.DESCRIPTION = [tbldefeic].[eic1n] "
    sql = sql & "& [tbldefeic].[eicsumn] "
    sql = sql & "& [tbldefeic].[eicsoun] "
    sql = sql & "& [tbldefeic].[eicmatn] "
    sql = sql & "& [tbldefeic].[eicsubn] "
    sql = sql & "WHERE (((tbltmpMobileS.PROID)=[tbldefeic].[eic]));"

Help?

[James Stanich]

Originally posted by Suidae
I have an Update statement which is working just fine but what I need are spaces between the joined fields. Robert Jones is showing as RobertJones.

    sql = "UPDATE tbltmpMobileS, tbldefEIC SET tbltmpMobileS.DESCRIPTION = [tbldefeic].[eic1n] "
    sql = sql & "& [tbldefeic].[eicsumn] "
    sql = sql & "& [tbldefeic].[eicsoun] "
    sql = sql & "& [tbldefeic].[eicmatn] "
    sql = sql & "& [tbldefeic].[eicsubn] "
    sql = sql & "WHERE (((tbltmpMobileS.PROID)=[tbldefeic].[eic]));"

Help?

Well...

where in this code is "Robert Jones" supposed to be? Try storing the name in a variable and sending it to the SQL statement that way...