Can anyone explain why the below Update statement misses one record in every instance? For example, let's say there are 50 records to be updated and there are 2 account numbers. So there are 25 records for each account number. The update statement below updates each account number but leaves only ONE record for that account number NOT updated. When I sort a query on the accounts, I can see that it is probably either the first or last record for that account that's not updated. Can anyone explain why this is happening and how to correct it?
strSQL = "UPDATE PTbl_Activity SET " & _
"QC_Complete = True, " & _
"QC_Complete_DT = Now() " & _
"WHERE PTbl_Activity.[LOAN NUMBER] = '" & iCurrLoan & "' " & _
"AND PTbl_Activity.PORTFOLIO = '" & iPortf & "';"
Thanks!
Mike
Tidak ada komentar:
Posting Komentar