Access Update Join

[ninken]

I've been a while since I used Access, I'm trying to write a update join
query,I've followed examples from here and the web, but Access throws a error
"use an updatable query". Can someone help?

Thanks

Some Methods that I tried...

UPDATE DISTINCTROW tbl_PreviousStockOut
INNER JOIN Qry_Stockout_Summary
ON tbl_PreviousStockOut.CategoryName = Qry_Stockout_Summary.ReportingGroup
SET Qry_Stockout_Summary.Today = tbl_PreviousStockOut.Previous;

UPDATE tbl_PreviousStockOut
INNER JOIN Qry_Stockout_Summary
ON Qry_Stockout_Summary.ReportingGroup = tbl_PreviousStockOut.CategoryName
SET tblPreviousStockOut.Previous = Qry_Stockout_Summary.TODAY

UPDATE tbl_PreviousStockOut
SET tbl_PreviousStockOut.Previous = (SELECT Qry_Stockout_Summary.TODAY FROM
Qry_Stockout_Summary WHERE Qry_Stockout_Summary.ReportingGroup =
tbl_PreviousStockOut.CategoryName)
WHERE EXISTS (SELECT Qry_Stockout_Summary.TODAY FROM Qry_Stockout_Summary
WHERE Qry_Stockout_Summary.ReportingGroup = tbl_PreviousStockOut.CategoryName)
;