Operation must use an updateable query (1 Viewer)

[jamest85]

Hi:

I am not sure if the update query let me using the data from another select query.

WATERPIPE is a table, and qrySrcTable is a SELECT query.

UPDATE WATERPIPE INNER JOIN qrySrcTable ON WATERPIPE.RECNUM = qrySrcTable.MB_RECNUM
SET WATERPIPE.[Break Type Points] = qrySrcTable .SumProblemPoints, WATERPIPE.[Break Age Points] = qrySrcTable .SumDatePoints;

The error shows: "Operation must use an updateable query".

The SELECT query: qrySrcTable works fine by itself, but once I am trying to get their data for my Update query, just not working.

I googled online, a lot of complains about this error: "Operation must use an updateable query", some people suggest to create a temp table to hold the data from that Select query, but that will be my last option.

Any suggestion how to fix it?

Thanks a lot.

 

[ajetrumpet]

MAYBE SEE THIS FIRST:

http://allenbrowne.com/ser-61.html