R. Choate said:
I'm doing an update query based on a select query (pulling from the
table which is getting the update), which contains aggregate
functions and always get this error. Why?
Press you F1 key in Access. Type the word updatable into the search field.
Click the first search result. Click the link to this help topic:: "When can
I update data from a query? (MDB)"
The "Data can't be updated" section describes the queries that are not
updatable. One of the types listed is queries containing aggregations. The
reason for this is the records in such a query's resultset are aggregations
of multiple records in the source table, so changes in that query's results
cannot be written to the source table. This is pretty much "by definition".
There needs to be a one-to-one relationship between the records in a query
and the records in the source table to allow the query to be updatable.
If you give us a better description of your problem, we might be able to
suggest a workaround, perhaps involving the use of domain aggregate
functions.
