RE: MS ACCESS - SIMPLE PROBLEM I JUST CAN'T GET MY HEAD AROUND
Your explanation of your problem leaves much to be desired. I have no idea what you are asking.
Do you wish to:
1) Update the other columns of rows in Table1 with values from rows in Table2 where DepartmentName matches? Note that this will not add any new rows to Table1, only change what is already there.
2) Copy rows from Table 2 to Table1, but only if rows containing the same DepartmentName value already exist in Table1?
3) Something else?
|