Update table using data from another table - MS Access

[Bo Long]

I believe the following a valid SQL statement, but MS Access returns
with an error "Operation must be an updateable query".

Any suggestions would be greatly appreciated!

UPDATE FERCPTILoad AS FL
SET FL.[Load Dist Factor] = FL.[MW]/(
select FA.[Load MW]
from FERCPTIArea AS FA
where FA.[Area Num] = FL.[Area Num of Bus]);

*** Sent via Developersdex http://www.developersdex.com ***

[pietlinden]

Bo Long wrote:

I believe the following a valid SQL statement, but MS Access returns
with an error "Operation must be an updateable query".

Any suggestions would be greatly appreciated!

UPDATE FERCPTILoad AS FL
SET FL.[Load Dist Factor] = FL.[MW]/(
select FA.[Load MW]
from FERCPTIArea AS FA
where FA.[Area Num] = FL.[Area Num of Bus]);

*** Sent via Developersdex http://www.developersdex.com ***

Why not try using DLOOKUP instead of the subselect? My guess is that
since the subquery could conceivably return more than one record, the
update query won't work.