Operation must be an updatable query ERROR (1 Viewer)

[Newbie_me]

Hello guys,

The newbie needs your help once again, I do have a Update query wherein i have a criteria involving a "SumOfQty" . However, it prompts me with "Operation must be an updatable query" error.
I tried to change it with the field "Qty" from the table and it works fine but i need the sum of quantity to meet the criteria.
I have no idea of the reason behind it. Is there any workarounds? Thanks in advance

 

[MajP]

Normally aggregate queries are not updateable queries. Thus it makes the insert not updateable. You can replace the sumofqty with a dsum and pass in the criteria.

Microsoft Access tips: Why is my query read-only?

List of reasons why a Microsoft Access query will yield non-editable results.

allenbrowne.com

 

[Newbie_me]

Normally aggregate queries are not updateable queries. Thus it makes the insert not updateable. You can replace the sumofqty with a dsum and pass in the criteria.

Microsoft Access tips: Why is my query read-only?

List of reasons why a Microsoft Access query will yield non-editable results.

allenbrowne.com

I will give it a try. Thanks!

 

[MajP]

Here is another article, but interesting it does not include dsums, or dlookups (domain functions)

Operation must use an updateable query, This Recordset is not updateable: Dealing with non-updateable queries in Microsoft Access

Operation must use an updateable query: Using temporary tables to bypass the limitations of recordsets which are not updateable

www.fmsinc.com

 

[Pat Hartman]

Typically you would not want to store a calculated value. It violates second normal form and leads to data anomalies. The best solution is usually to calculate the sum as you need it.

If you can tell us more about the requirement, we'll have a better chance of coming up with a good solution.