UPDATE fields based on another table

[jaryszek]

Hi Guys,



I have table1 with TEXT fields:
Field1
Test1
Test2
Test3
Test4

In Table2 i have dictionary for it, so:
Field1, Field2
Test1, Ok
Test2, No
Test3, Yes
Test4, No problem

So i want to write SQL query to update fields in Table1 using Table2:

UPDATE Customers
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;

So in my example:

UPDATE Table1
SET Field1= "Ok"
WHERE Field1 = "Test1"

UPDATE Table1
SET Field1 = "No"
WHERE Field1 = "Test2"

and so on and so on.

So insted of writing 10 times this SQL query i would like to create automation for it.
Maybe using Dlookup function or VBA?

Can you please help me?

Warm regards,
Jacek Antek

[ranman256]

in the query , add both tables to the query,
join the field1 on both,
now update using

set table1.field1 = table2.field2

[jaryszek]

Thank you Ranman256 !!!

Best Wishes,
Jacek