Bonsoir James,
Votre update ne respecte absolument pas la syntaxe SQL, laquelle est la suivante (extrait de l'aide d'ACCESS) :
UPDATE table SET newvalue WHERE criteria ;
The UPDATE statement has these parts:
Part |
Description |
table |
The name of the table containing the data you want to modify. |
newvalue |
An expression that determines the value to be inserted into a particular field in the updated records. |
criteria |
An expression that determines which records will be updated. Only records that satisfy the expression are updated. |
Vous pouvez vous inspirer de cette requête qui fonctionne avec MySQL :
UPDATE tblClient
SET txtNewFieldName = (SELECT tblImport.txtNewFieldName2 FROM tblImport WHERE tblimport.Account_Id = tblClient.Account_Id)
WHERE EXISTS (SELECT ''
FROM tblImport
WHERE tblImport.Account_Id = tblClient.Account_Id)
;
Bon courage !
Partager