Update query wont work?

[Tony Williams]

I have a simple update query here is the sql
UPDATE Semita INNER JOIN Test2 ON Semita.txtVRM = Test2.Field1 SET
Semita.txtStatus = [test2].[Field7];

But when I run it nothing happens. Anyone figure out what I'm doing wrong, I
thought this was relativly simple?

 

[Jerry Whittle]

Nothing happens? No error message? No "X number of records being updated"
message?

If that is so, it's possible that you have Set Warnings off somewhere and
it's hiding an error message that might tell what is wrong.

Try the following and see if any records are returned:

Select Semita.txtVRM, Test2.Field1
From Semita INNER JOIN Test2
ON Semita.txtVRM = Test2.Field1;

If not, try the following:

Select Semita.txtVRM, Test2.Field1
From Semita LEFT JOIN Test2
ON Semita.txtVRM = Test2.Field1;

Select Semita.txtVRM, Test2.Field1
From Semita RIGHT JOIN Test2
ON Semita.txtVRM = Test2.Field1;