I need help with a SQL statement.
I need to update TWO tables in one go! The two tables are called tbl_ManifestDet and tbl_Accounts.

Here is my statement below. Currently it updates my first table called tbl_ ManifestDet with a dexcode and AccountNo. I need to update the field called "manifested" & set it to "N" in another table called tbl_Accounts. How do i write this?

VB Code:
  1. strSQL = "UPDATE tbl_ManifestsDet SET dexcode = '" & reason & "', manifested = 'N' WHERE AccountNo = '" & Mem(SockNr) & "'"

  2.             adoConn.Execute strSQL