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?