How can you store a value calculated in a query in a table?

How can you store a value calculated in a query in a table?You don't normally ever do this. As a general principle you don't store calculated data. The point being you can always use a query to recalculate the data as and when you need it.

What is it that you are calculating?

Chris

Stock Levels.

How do you know what it is(I have a filed as quantity in table as well.)?

Stock levels are generally calculated by summing a list of +/- transactions. No need to keep a record for the current stock as well. I'd recommend you search these forums for "stock control" or "stock management" or something along those lines as the problem of stock in a database is discussed many times.

Chris