MS Access 2003: Update Query that updates values in one table ...

UPDATE Bot SET Bot.MFG = (SELECT Big.MFG FROM Big WHERE Big.PART = Bot.PART) WHERE EXISTS (SELECT ...

www.techonthenet.com