How update table needing a join ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to update a column in a table but to do this I need to look at a columnn in another linked table.
How do I do this? The Access help seems to indicate that I can only look at columns in the table I am updating.

Logic needed: if column1 in Table A is NULL. I need to look at the joined table and if the value in column1 there is not null, I need to replace column1 in table A with the value in column2 of table B.
 
Are the tables joined by at least one primary key?

--
Duane Hookom
MS Access MVP


David said:
I need to update a column in a table but to do this I need to look at a
Click to expand...
columnn in another linked table.
How do I do this? The Access help seems to indicate that I can only look
Click to expand...
at columns in the table I am updating.
Logic needed: if column1 in Table A is NULL. I need to look at the joined
Click to expand...
table and if the value in column1 there is not null, I need to replace
column1 in table A with the value in column2 of table B.
 
Back
Top