Update Queires

[gblack]

OK,
I have a table that I want to update and a table with the new values for the field I want to update.

Basically I have a table with one record for each state. One field in that table is “Category”. The category for each record is “Net Collections”. For each net collections there is a corresponding “Totals” field.

What I want to do is link my “New Values” table to my main table via the “State” field, then update the records in my main table from the totals field in my “New Values” table, but when I try to do the Access says: “Operation must use an updateable query”. Why is this not updateable? Actually I don’t care about that question as much as I do: How can I get this update to work?

Thanks,
Gary

 

[aleb]

Here is a solution:
The reason why you get this kind of message is because you use an aggregate function to get the total value.
Well at this stage:
From the first query ( the one with aggregated function ) create a "make table query", once a new table will be create, create a second query (update query ) which will update the records where you need them.