Concatenation with spaces

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.

Code:

---

    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?

Quote:

---

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.

Code:

---

    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...