Hi, can someone please help. This update query takes very long time to run. Just wondering if this can be achieved with VBA perhaps it will be quicker to update customer field based on criteria in query below.
UPDATE tblFinal INNER JOIN tblList ON tblFinal.Type = tblList.Range SET tblFinal.Customer = tblList!Customer
WHERE (((tblFinal.CodeNumber)>=[tblList]![StartRange] And (tblFinal.CodeNumber)<=[tblList]![EndRange]));
Thanks in advance
GR
UPDATE tblFinal INNER JOIN tblList ON tblFinal.Type = tblList.Range SET tblFinal.Customer = tblList!Customer
WHERE (((tblFinal.CodeNumber)>=[tblList]![StartRange] And (tblFinal.CodeNumber)<=[tblList]![EndRange]));
Thanks in advance
GR