Access 2003: How to update TableA from TableB based on condition

I'm getting error "Operation must use an updateable query" with the following code, any help would be greatly appreciated.

update reportbyjobt开发者_如何学Cable 
set [StepAtPP22010]  = (SELECT TOP 1 PTTIMERATE.STEP FROM PTTIMERATE WHERE PTTIMERATE.TIMEREQUIRE<= REPORTBYJOBTABLE.TOTALHOUR93TOPP012010 
ORDER BY PTTIMERATE.TIMEREQUIRE DESC)
where [benefits start date]>#8/28/2010#

Thanks so much!

make shure the "reportbyjobtable" is a table, not a query.

try to build another query with the "select" statament wich is used to update the [stepAtPP22010] field. Save this query and build another query using the result column from the first query saved to update the "reportbyjobtable" table. Be care using the correct relationship type between queryes and tables.