This is my Sql coding
UPDATE Book1 T1
SET [newlocation-ID] = DMin("IdLocation","Book1",
"Address LIKE '" & Address & "*' OR '" & Address & "' LIKE (Address + '*'")
EXISTS (Select T2.IdLocation FROM Table2 T2 WHERE (T1.Address LIKE (T2.Address + '*') OR T2.Address LIKE (T1.Address + '*'))AND T1.PC = T2.PC AND T1.IdLocation <> T2.IdLocation)
Please find the attachement folder for Erors and Table format.
Errors showing i can't update the records. the error in the attachment folder