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

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


"John Ortt" wrote in message
...
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