Query Calculations

  • Thread starter Thread starter Matt Newton
  • Start date Start date
M

Matt Newton

Is it possible to carry over the result of one calculation
and use it in another. For example I currently have a
query setup with the following fields:

Stock ID, Stock Name, Part Number, Stock Value, Supplier,
Stock In and Quantity Used.

At the moment I have a calculation setup so that
the 'Quantity Used' is deducted from the 'Stock In'
resulting the amount of stock available. I did this using
the following calculation - Stock Available:([Stock In]-
[Quantity Used]). For example: 200-13=187

What I want to do is carry over the new 'Stock Available'
figure (in this case 187) so that when another quantity
figure is entered it deducts it from the new figure (187)
rather then the old figure of 200.

There are currently over 9 different stock items and would
need to do this for each one

Hope this makes sense. Any help would be appreciated.
Thank You.
 
You can certainly bring one query into another just like you would a table.
Short of knowing much more about your database, you might want to try that
provided you can link by your key field (StockID ?).
 
Back
Top