Recent content by summer23

I know that step, and already did it, but when I lookup value from "table 2" with Vba code to update on new ID, it error "circular reference cause by alias 'ID' in query definition's SELECT list". if i use Dlookup, it only return the first result and show that result replicate till the end of...

my ID client table is like this: Client - ID - other infomation ABC - 20016 - x CDE - 20015 - y EFG - 20017 - z QWE - 10004 - g this is the DATA in the "temp table" that I import from excel, and excel is downloaded from company's system, this excel's data has old ID number (start with 2...