Update query problem

  • Thread starter Thread starter senor_baub
  • Start date Start date
S

senor_baub

I am trying to use an Update query to replace the values in a table with the
result of a select query but I keep getting the message 'Operation must use
an updateable query'.

Are Update queries not allowed to use data from Select queries?
 
Access is quite picky about what is allowed in any updateable query. You must
join on a primary key field of the query/table providing the update to value.

If you shared you SQL and table structures, someone might help you re-write
your query.
 
Back
Top