"Must use updateable query" problem

[marlun]

Hi. I have a table that needs to be updated with an updatequery, but when I run it I get something like "Must use updateable query". My updatequery gets its value from an select query that calculates a Sum. How do I do to prevent that from happening or is there any other way to update my table.

Please help

 

[danvlas]

If any of the 'sources' of a query is not updatable, the query is not updatable.

Either open a recordset and do your stuff there or remove the Sum query and use DSum function to calculate what you need.

Update YourTable Set YourField = DSum("FieldToSum","SumTable","CriteriaToLimitTheSum&quot

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html