Update query help needed! 1

[SarasotaIT]

I am trying to increase a field's value in tbl1 by 2 if the same account number exists in tbl2. I think I may be partially there but Access returns an error. Here's what I have...

UPDATE tbl1 SET fld = fld+2
WHERE (SELECT T1.account, T2.account
FROM tbl2 T2, tbl1 T1
WHERE T1.account=T2.account);

Thanks much in advance!
Terry

 

[r937]

try this --

[tt]UPDATE tbl1
INNER
JOIN tbl2
on tbl1.account = tbl2.account
SET fld = fld+2[/tt]

rudy

http://r937.com/

 

[SarasotaIT]

Thanks much, Rudy! You helped me out of the abyss! Kudos!
Terry