Dears
In my VBA Code I have a string as below
scriptstatementJT = "Insert into JOBTASK(JPNUM, JPTASK, DESCRIPTION) Values('" & jpnum2 & "','" & task & "','" & Description& "')";
I have a DataBase Table Called JTQUERIES i want to insert data to it
strSQL = "INSERT INTO JTQUERIES (JOBPLAN,JPTASK,JTQUERY) VALUES ('" & jpnum2 & "','" & task & "', """ & [scriptstatementJT] & """ ); "
Set cn = CurrentProject.Connection
cn.Execute strSQL
the problem is that i am having a syntax error when every time the Description Field is having a Double Quotations (") in its value. ex: Description = "Hello World How "Are You"";
How can I solve this Problem?
Thank you