I am trying to update a table based on the values from a subquery and am getting an error stating "Operation must use an updateable query."

I am much more familiar with MS-SQL, but unfortunately that syntax doesn't work. Using the design, i get the following query.

UPDATE physicalinventory INNER JOIN LastInventoryAdj ON (physicalinventory.InvSite = LastInventoryAdj.TR_Site) AND (physicalinventory.ContainerID = LastInventoryAdj.TR_ContainerID)
SET physicalinventory.applydate = Now(), physicalinventory.trid = lastinventoryadj.trid


where physicalinventory.trid is null and physicalinventory.status = 'Y';

LastInventoryAdj is another query which gets the max(trid) for each item.