C
Cheryl Lamonds
I am trying to create an update query and get the message
shown in the subject when I try to run it.
Table 1 is linked to Query 1 by three fields. Query 1 is
a summary query.
Two numeric fields in Table 1 are to be updated to a
value calculated from a field in Table 1 and a field in
Query 1.
When I run the query, I get "Operation must use an
updatable query". I have read the Help and looked online
for an answer and found nothing that helps.
When I replace Query 1 with the source table for Query 1,
it runs fine.
I am not trying to update Query 1, so what is the message
trying to tell me?
shown in the subject when I try to run it.
Table 1 is linked to Query 1 by three fields. Query 1 is
a summary query.
Two numeric fields in Table 1 are to be updated to a
value calculated from a field in Table 1 and a field in
Query 1.
When I run the query, I get "Operation must use an
updatable query". I have read the Help and looked online
for an answer and found nothing that helps.
When I replace Query 1 with the source table for Query 1,
it runs fine.
I am not trying to update Query 1, so what is the message
trying to tell me?