"Operation must use an Updateable Query." - How do I get round this?

  • Thread starter Thread starter John Ortt
  • Start date Start date
J

John Ortt

I have a table of sales data which I want to summarise into daily sales
figures and update a table with.

The problem is that if I create the Summary Query and then try to use it to
update the Summary table I get the following error:

"Operation must use an Updateable Query."

Even though I am only trying to update the Table. Does anybody know a way
around this other than to create a temporary table and use that?

Thanks in Advance,

John
 
Hi,


Try using DSum rather than SUM. As soon as there is an aggregate, the
query is annotated as not being updateable, even if you don't try to update
the SUM, as example.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top