operation not an updateable query

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

Guest

Is it possible to use the results of a query in an update query i.e. as the
values to update to? I keep getting an error message (as set out in the
subject of my post) when I try it .
 
This is a very complicated subject. I suggest that you open up Access Help,
go to the Find tab, type in "updatable" (lower case u) or "About updating
data", and then scroll down to "When can I update data from a query?" or "Why
can't I edit data in my form?". There you will find a lot of, possibly too
much, information on the subject. In a nutshell, if the query is based on one
table or tables with a one-to-one relationship, you will be able to edit or
delete records. If it is based on two or more tables with a one-to-many
relationship, you 'should' be able to edit or delete records. If you have
three or more tables based on many-to-one-to-many relationships, you will not
be able to edit or delete records. This is just the highlights. Help has much
more information.
 
Yes it is possible, but you can't use any aggregate functions (SUM, MIN,
MAX)

IF you post the SQL of your queries, someone may be able to help you rewrite
the code.


Open in Design view, select View SQL, Copy and paste to your message.
 
Back
Top