PDA

View Full Version : Update query in ms access



lienlee
08-04-2010, 05:51 AM
UPDATE ExportToTable LEFT JOIN Integration_Interface ON ExportToTable.ID = Integration_Interface.Integration_Interface_ID SET ExportToTable.I_I_name = [Integration_Interface].[Integration_Interface_Name];

When i hit run to run this query. nothing happens. is something wrong with my query?

attached is the relationship between the two tables

XLGibbs
08-05-2010, 10:41 AM
When you say "nothing happens"...there is no error message...nothing at all?

What happens when you run this:



Select ExportToTable.ID, Intergation_Interface.Integration_Interface_ID FROM ExportToTable
LEFT JOIN Integration_Interface ON ExportToTable.ID = Integration_Interface.Integration_Interface_ID


Do you get results?

HannaPearson
09-07-2010, 01:07 AM
Thank you for this. I got it working on my computer now.