Update

[blander]

Hi Guys,

Two Tables:

module
workbook2



UPDATE workbook2 INNER JOIN [module] ON workbook2.ID = module.ID SET workbook2.bankimpid = module.BAImpID
WHERE ((([BASortCode])=[Sortcode]));

Any ideas why this changes 0 records when some records contain the same data in BASortCode and Sortcode??

Cheers

 

[neileg]

Is the join working and returning data? Try a simple select query to see if you get any records. If workbook2.ID and module.ID are different datatypes the join may not work.