Syntax error on update query

[TonyKhela]

Hi,

I need to run something like:

UPDATE tblDirectDebitInst

SET tblDirectDebitInst.[Next Processing date]=#5/22/2007#

FROM tblMembers INNER JOIN (tblDirectDebits INNER JOIN tblDirectDebitInst ON tblDirectDebits.fklddid = tblDirectDebitInst.ddidno) ON (tblMembers.[Id No] = tblDirectDebits.[Id no]) AND (tblMembers.[Id No] = tblDirectDebitInst.[Id no])

WHERE (((tblDirectDebitInst.[Next Processing date])=#4/22/2007#));

But I'm getting a syntax error.
Can someone assist?

Thanks in advance.

TK

 

[Crowley16]

ah, you're using the t-sql syntax for update, in jet it's:

update table1 join table2 on table1.col1 = table2.col2
set ...
where...

--------------------
Procrastinate Now!