CODEWITHSUNDEEP
vbams-access
Ramya
Ramya

Reputation: 51

Access- Vb- updating one table based on other table's value

I am using Access DB with vb. I want to update the values of one table base on other tables values

for example Table A has columns a1, a2, a3,..... Table B has columns b1,b2,b3.......

if a1 and b1 are he ID numbers, for each matching ID in table B, the value of B3 has to be updated in a3 as well

If first value of b1 is 1234, then search for 1234 in tableA , the update tha a3 position of that particular row with b3 value.

Please let me know how to move on with this.

Upvotes: 2

Views: 2578

Answers (1)

Fionnuala
Fionnuala

Reputation: 91356

Try this. It may not work if you do not have suitable indexes.

UPDATE KeyTable090808 
INNER JOIN pplsft_IDandDEPT 
ON KeyTable090808.Employee_ID = pplsft_IDandDEPT.pplsft_UTDID
SET KeyTable090808.DEPT = pplsft_IDandDEPT.pplsft_Dept_Name

Upvotes: 3

Related Questions