update query not updatable

  • Thread starter Thread starter Jazinwaz
  • Start date Start date
J

Jazinwaz

I have Table A and Query B with the same four fields. If three of the fields
match, then I want to take the fourth field (which is a summation) from Query B
and copy it to the fourth field in Table A. Whenever I try to run an update
query to do this, I get the message Operation Must Use An Updatable Query.

The mere presence of Query B in my update query, whether I refer to it or not,
causes the above error message. I tried using a Dlookup in the Update To
field, but this does not resolve the problem.

Is there a way to correct this? If not, is there a way around it?

Thanks!
 
The mere presence of Query B in my update query, whether I refer to it or not,
causes the above error message.
Click to expand...

Yes, annoyingly enough, it does: any query including a Sum operation
is ipso facto non-updateable, even if it logically should be!
I tried using a Dlookup in the Update To
field, but this does not resolve the problem.
Click to expand...

You should be able to do the summation using DSum() (rather than a
Totals query).
 
Back
Top