Update Query Not Updatable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Table A and Query B with the same four fields. If
three of the fields match, then I want to copy the fourth
field from Query B (a summation result) to the fourth
field in Table A. No matter how I create the update
query, I receive the message Operation Must Use an
Updatable Query.

If I remove Query B from the update query, then I do not
get the error message. As soon as I add Query B to the
update query, whether I refer to it or not, I receive the
error message. I tried using DLOOKUP in the Update To
field, but this does not resolve the issue

Am I attempting an impossible task? Is there a way around
this?

Thanks!
 
You might have to use recordset commands in Visual Basic
to do this.

You may wish to rethink your data model.

Why don't you just link the 4th field to your table by
using your Relationsship settings. Also, you can create 2
queries with and expresion - Expr1: field1+field2+field3
in each query.

Than you can match/link the two Expr1 fields in the
queries. In other words, your first table.
 
Another workaround fo this is

Create a new table identical to Query B using a make-table query

Then, use the new table to update the field on Table A

----- Kevin wrote: ----

You might have to use recordset commands in Visual Basic
to do this

You may wish to rethink your data model

Why don't you just link the 4th field to your table by
using your Relationsship settings. Also, you can create 2
queries with and expresion - Expr1: field1+field2+field3
in each query

Than you can match/link the two Expr1 fields in the
queries. In other words, your first table
 
Back
Top