Operation must use an updateable query - help

[fluffyvampirekitten]

I have an existing table - DuplicateSystemEPOS


and query DuplicateSystemEPOS

I would like to update my table ( NO_OF_INSV) column from a query result
However , whenever I run this query , I keep getting operation must use an updateable query

Anyone could help me ? Is there any other way to solve this .

I have been trying to write other way of "UPDATE" statement but I keep getting the same error
Below is the code that I'm using and my file is NOT "read-only" and yet access doesn't let me update

UPDATE DuplicateSystemEPOS INNER JOIN DuplicateSystemEPOSins 
ON DuplicateSystemEPOS.GROUP_NO = DuplicateSystemEPOSins.GROUP_NO
SET DuplicateSystemEPOSins.No_of_INSV =DuplicateSystemEPOS.NO_OF_INSV;

[June7]

Are you trying to save aggregate data? Saving calculated data is usually not advised, especially aggregate data. Aggregate data should be calculated when needed.

You state table and query have the same name yet the names are different in the SQL.

[fluffyvampirekitten]

Yeah I was trying to save aggregate data.
Is there any way to save an aggregate data ?

[June7]

Only alternative is VBA code that cycles through recordset object.

As I said, it is not advised to save aggregate data.

[fluffyvampirekitten]

Only alternative is VBA code that cycles through recordset object.

As I said, it is not advised to save aggregate data.

Hmm I see..
but I was trying to count how many LV_INS records where group no = group no because my table have duplicates
here is the code

SELECT DISTINCT DuplicateSystemEPOS.GROUP_NO, Count(DuplicateSystemEPOS.LV_INS) AS NO_OF_INSV
FROM DuplicateSystemEPOS
GROUP BY DuplicateSystemEPOS.GROUP_NO;

[June7]

I am not sure what you want. Post examples of raw data and desired output.