I have this SQL Statement that i would like to do, but i don't think the syntax is correct, could someone help please.
SqlRs = "INSERT INTO Entry_de (Error Code) values ('" & ErrCodeE & "') where [Batch Number] = " & WBBatchNumber & " And [Entry Number] = " & LineNo & ""
Basically what i would like to do, is - I would like to insert a value into a certain field in a table, according to certain criteria. The column name is Error Code, and i would like the value ErrCodeE to be inserted into that field. The Entry_de is the table i would like to insert this value. And the criteria, is that i would like the ErrCodeE to be inserted where the Batch Number = x, and Entry Number = y.
Please could someone help.