I am trying to update fields in my tables. I made an update query and updated thousands of records using data drawn from another table. Then I needed to update another field in the same table, but this time the data is in a query. I get “Operation must use an updateable query” every time I try to run the update query. I can change the update query to a select query and it runs with no errors. The query that the update query is drawing from is not updateable, but I am not trying to update the query, I am trying to update a table. If the data is there, why won’t it just write it to the table? I have a report that prints this out every day, but I need to start saving it in the table for historical analysis.
Any ideas?