|
RE: MS ACCESS - SIMPLE PROBLEM I JUST CAN'T GET MY HEAD AROUND
Ok. Right click in Query Designer, select SQL view, and type the following (adjusting for your table and field names):
UPDATE Table1 INNER JOIN Table2 ON Table2.DepartmentName = Table1.DepartmentName SET Table1.Col1 = Table2.Col1, Table1.Col2 = Table2.Col2
You may, of course, have more than two columns you want to update. I quickly tested it (since I normally work with SQL Server and Access only supports a subset of T-SQL) and it works.
I don't know whether or how you can create such a query in the drag-n-drop designer mode. I noticed that after having it saved, Query Designer doesn't seem to be able to display it otherwise than just straight SQL.
| 
