where clause: missing semicolon at end of SQL statement

<i><b>Originally posted by : Chris (csbelli@hotmail.com)</b></i><br />I am trying to do an insert statement with a where clause from ASP to Access 2000. This is my insert statement: strSQL = strSQl & "INSERT INTO Results2 (q1a,q1b,q1c,q1d) VALUES('" & q1a & "','" & q1b & "','" & q1c & "','" & q1d & "') WHERE ssn = 'ssn1' ; " I have tried every combination I can think of but I always get missing semicolon at end of SQL statement or Expected end of statement. Any help would be greatly appreciated. Thanks.<br />

<i><b>Originally posted by : Bob (bmacneal@dainrauscher.com)</b></i><br />I don't think you need a semi colon at the end of the query. Try it without. Other than that it looks ok.<br /><br /><br />------------<br />Chris at 4/17/2000 12:33:43 AM<br /><br />I am trying to do an insert statement with a where clause from ASP to Access 2000. This is my insert statement: strSQL = strSQl & "INSERT INTO Results2 (q1a,q1b,q1c,q1d) VALUES('" & q1a & "','" & q1b & "','" & q1c & "','" & q1d & "') WHERE ssn = 'ssn1' ; " I have tried every combination I can think of but I always get missing semicolon at end of SQL statement or Expected end of statement. Any help would be greatly appreciated. Thanks.<br />