Hi,
I have written a function to loop through a table & concatenate all the Add_Info for a specific job & write it back to new table in 1 record.
On some the existing data I am getting errors, these seem to be caused by the use of ' in the concatenated text, also it appears that other characters may also be causing this.
Please could you look at my sql statement below as I believe I may have used the wrong " or ' in it.
strSQL = "INSERT INTO tblJobInfo (JOBL, ADD_INFO) " _
& "VALUES ( ' " & strJobNo & " ' , ' " & strInfo & " ' )"
JOBL is a unique job number which is alphanumeric & ADD_INFO is also alphanumeric.
Thanks in advance
Tim
I have written a function to loop through a table & concatenate all the Add_Info for a specific job & write it back to new table in 1 record.
On some the existing data I am getting errors, these seem to be caused by the use of ' in the concatenated text, also it appears that other characters may also be causing this.
Please could you look at my sql statement below as I believe I may have used the wrong " or ' in it.
strSQL = "INSERT INTO tblJobInfo (JOBL, ADD_INFO) " _
& "VALUES ( ' " & strJobNo & " ' , ' " & strInfo & " ' )"
JOBL is a unique job number which is alphanumeric & ADD_INFO is also alphanumeric.
Thanks in advance
Tim