Operation must be an updatable query

F

FRED

I want to update field A from table B with the following updatable query " UPDATE B SET A = (select D from E where F = B.C) and it return s me an error saying that it should be an updatable query. Is ther any way to update a table field from a query or you should first run a make table query and from the table add to the field ?

Thanks
 
Top