operation must use an updatable query

[tomk01]

why am i getting this message?

update tempaccrreport
inner join caccrchart on tempaccrreport.bcode = caccrchart.bcode
set tempaccrreport.accrRate = (select max(caccrchart.accrualRate)
from caccrchart)
where tempaccrreport.mos > (select max(caccrchart.minimumService)
from caccrchart)

 

[JonFer]

Usually this is because Access wants to be able to uniquely identify a record when updating it. What indexes are on each table and how are the tables related?

John

http://www.interautomateconsulting.com