Query to update table with data from another

  • Thread starter Thread starter Paul Wilson
  • Start date Start date
P

Paul Wilson

Hi,

I have 2 new tables which are originally from a single table. I wish to
update "CONTACTS" table's "DEALERID" field from the "DEALER" table's "ID"
field based on "DEALERNAME" which appears in both tables?
 
Paul

Have you looked into UPDATE queries?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Backup your database first. Backup your database first.

You also might want to run a select query first like this --
SELECT SET [CONTACTS].[ID], [DEALER].[ID]
FROM [CONTACTS] INNER JOIN [DEALER] ON [CONTACTS].[DEALERNAME] =
[DEALER].[DEALERNAME]
WHERE ((([CONTACTS].y) Is Null));

Then do update --
UPDATE [CONTACTS] INNER JOIN [DEALER] ON [CONTACTS].[DEALERNAME] =
[DEALER].[DEALERNAME] SET [CONTACTS].[ID] = [DEALER].[ID]
WHERE ((([CONTACTS].y) Is Null));
 
Back
Top