Query Data not updating

[junior6202]

Hi All,



I'm Trying to figure out why a query is not updating quantity column in access 97. I have broken the query all the way to the table that produces the qty but not quite figure out whats wrong. Can anyone please guide to the right direction on what to do. Thank you in advance.

[JoeM]

You'll need to provide more details, such as the SQL code of your query (change to SQL view and copy and paste the SQL code here).

I am also not clear on your question.
Is this an Action query, where the query itself is supposed to update the underlying data?
Or, are you manually trying to update data via a query? Not all queries are updateable?
Or are you saying that the query is not reflecting recent changes to your underlying data?

[June7]

Saving calculated data, especially aggregate calcs, is usually a bad idea. Aggregate data should normally be calculated when needed. If you need to know quantity on hand - sum quantity received and sum quantity used and calc the difference. http://allenbrowne.com/AppInventory.html