Update error

[phong919]

Can someone look at this update statment i just wrote? It's giving an error.

i.e.

UPDATE [Upload Trades] LEFT JOIN UploadAccts ON [Upload Trades].CustAcct = UploadAccts.CustodyAccount SET [Upload Trades].Client = [uploadaccts].[client], [Upload Trades].Account = [uploadaccts].[account]
WHERE ((([Upload Trades].Account)<>[uploadaccts].[account]));

Error msg - "Operation must use an updateable query"

Thank you.

 

[IgorB]

Your update expression:
SET [Upload Trades].Client = [uploadaccts].[client], [Upload Trades].Account = [uploadaccts].[account]

looks wrong. You tried to update Client filed and Account at the same time(it is impossible, do each update one at a time).
Also "not updatetable" indicated that your sources involved in update might contain more than 2 sources.