Is there a workaround to "Operation must use an updateable query" error

Using Access 2000/2002

I have a table that has various item attributes, including a "qty on
hand" column.
I have a separate table that has my inventory by specific location.
I have a query that summarizes the inventory to provide me a total on
hand quantity for each item. The SQL I am using is this:

UPDATE ITEM_TRACKER INNER JOIN qryGRAB_CRB_SFO_INV
ON ITEM_TRACKER.Item = qryGRAB_CRB_SFO_INV.SEGMENT1
SET ITEM_TRACKER.SFO = [qryGRAB_CRB_SFO_INV]![sfo], ITEM_TRACKER.CRB =
[qryGRAB_CRB_SFO_INV]![crb];

When I run it. I get the error message in the subject line.

There is no issue with read/write/permissions, as other update queries
work fine.

I actually solved this issue on my own 5 months ago, but I will be
darned if I can find where I saved the query that works properly


I know I could do a temporary table and then do the update and then
delete the table. But I KNOW there is a way to do this.