
Originally Posted by
June7
You can use the query builder to help build query objects. Can also open query builder in SQL View and copy/paste the sql statement. Should be 3 query objects then just run them.
Ooops, I forgot part of the DLookup
UPDATE Table1 SET Phone1 = Null WHERE Not IsNull(DLookup("Phone1","Table2", "Phone1='" & [Phone1] & "'")) Or Not IsNull(DLookup("Phone2","Table2", "Phone1='" & [Phone1] & "'"));
UPDATE Table1 SET Phone2 = Null WHERE Not IsNull(DLookup("Phone1","Table2", "Phone1='" & [Phone2] & "'")) Or Not IsNull(DLookup("Phone2","Table2", "Phone1='" & [Phone2] & "'"));