Operation must use an updateable query message

[valeryk2000]

This is my query:
===============
UPDATE tblMortalityReview INNER JOIN qryInitialUnit
ON tblMortalityReview.EncounterNumber = qryInitialUnit.EncounterNumber
SET tblMortalityReview.InitialUnit = qryInitialUnit.Unit;
==============
Why it is not "updatable"?
Thanks

 

[jdraw]

see this info

 

[spikepl]

No it isn't your query. You have a qryInitialUnit which is not shown.

 

[valeryk2000]

To skikelp:
This is the query (returns one unit to each EncounterNumber - no duplicates!):
============
SELECT EncounterNumber, Unit
FROM
(SELECT t.EncounterNumber, Unit FROM tblPatientUnits AS t
INNER JOIN
(SELECT tblPatientUnits.EncounterNumber, min(tblPatientUnits.DateOfEntry) AS MinDate FROM tblPatientUnits
WHERE DateOfEntry>#1/1/2014# GROUP BY EncounterNumber) AS b
ON (t.DateOfEntry=b.MinDate) AND (t.EncounterNumber=b.EncounterNumber)) AS a;
================