Update query problems

[sando]

I created a update query a few days ago. It worked fine at the time. Now I get a error: "Operation must use an updateable query"

Nothing has changed on my database. Other update queries still work.
If I create another database and import the query and the table I want to update i can create a new update query that works. But I don't want more than one db.

any ideas?

Thank you in advance

 

[sando]

I don't fully understand it. But here it goes.

When updating a table froma query Access does not seems to like it when the query is grouped.

Go figure