Operation must use an updateable query

[Taylor]

I get this error everytime I run my query. I am basically trying to
copy a field from one query to a table (the query and the table are
joined by a unique ID). This is my SQL:

UPDATE Staff INNER JOIN [Grade Calculator] ON Staff.EmployeeID=[Grade
Calculator].StaffID SET Staff.1stQuarterGrade = [Grade
Calculator].[1stQuarterCalc];

Does anyone know why I would be getting this error? Thanks for your
help.

 

[John Vinson]

I get this error everytime I run my query. I am basically trying to
copy a field from one query to a table (the query and the table are
joined by a unique ID). This is my SQL:

UPDATE Staff INNER JOIN [Grade Calculator] ON Staff.EmployeeID=[Grade
Calculator].StaffID SET Staff.1stQuarterGrade = [Grade
Calculator].[1stQuarterCalc];

Does anyone know why I would be getting this error? Thanks for your
help.

I would guess that [Grade Calculator] is a Totals query, or has some
totals operator such as Sum, Count, Avg etc. No Totals query nor any
query including a Totals query is ever updateable.

If you can calculate the 1stQuarterGrade (using this query?) at any
time, generally you *should* just calculate it. Storing the grade in
your table risks data validity errors if any of the fields that went
into the calculation ever get edited - if they do, you'll have a
stored grade WHICH IS WRONG and no indication of that fact. Worse, the
stored grade could be edited, innocently or maliciously, giving no
indication that it's been raised or lowered.

John W. Vinson[MVP]