Hello,
I have created a SQL statement to update my Audit table within my database and keep receiving the Syntax error in UPDATE statement error message and cannot figure out why.
Its in my strSQL2 statement but here is the majority of my coding:
Please HELP!!! I've been working on it for almost 2.5 hrs now!
I should add that I ran it in the immediate window and everything returns a value, the only thing I see odd is some of the premiums are "0" instead of "0.00" as those are currency fields. Not sure if this is the issue or how to correct. Here is the result from my immediate window:
UPDATE tblAudit set tblAudit.audAuditorDateT1 = Date(), tblAudit.audTimeStampT1 = Now(), tblaudit.audGrpName = 'EQUITY TRANSPORTATION', tblaudit.audEmpSSN = '7527607', tblaudit.audEmpName = 'SOMERS, EVERETT', tblaudit.audGrpNumber = '5775', tblaudit.audACPrem = 5.61, tblaudit.audCIPrem = 0, tblaudit.audHIPrem = 0, tblaudit.audSTPrem = 0, tblaudit.audLTPrem = 5.61, tblaudit.audCAPrem = 0, tblaudit.audTLPrem = 0, tblaudit.audWLPrem = 0, tblaudit.audDNPrem = 0, tblaudit.audTotPrem = 5.61, tblaudit.audBillCode = '700', tblaudit.audCertificate = '5775000011', WHERE (((tblAudit.audAuditID)='DR000023'));
Thanks!
Amy