Operation must be an updatable query ERROR

[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