UPDATE statement help for Access

[AdventurGurl]

The following query tells me incorrect syntax near FROM??

UPDATE c SET c.ac_id = b.ac_id
FROM ((Account a
INNER JOIN Account b
ON a.ac_number = b.ac_number)
INNER JOIN scanned_document c
ON a.ac_id = c.ac_id)
WHERE a.ACT_ID IN (59,60,61,62,63,64,65)
AND b.ACT_ID IN (71,72,73,74,75,76,77));

Any ideas? Thanks in advance!

 

[PWise]

try

UPDATE (c 
INNER JOIN Account b 
ON a.ac_number = b.ac_number)
INNER JOIN scanned_document c 
ON a.ac_id = c.ac_id
SET c.ac_id = b.ac_id 
WHERE a.ACT_ID IN (59,60,61,62,63,64,65)
AND b.ACT_ID IN (71,72,73,74,75,76,77));

 

[PWise]

note that this is ever going to update any records
as this is a self join (the same records)

so if a.ACT_ID IN (59,60,61,62,63,64,65) then b.ACT_ID can not be IN (71,72,73,74,75,76,77)