Query to calc balance

[CoachBarkerOJPW]

I have a table and three of the fields are AmountBought, AmountSold and
AmountInStock. In a query how do I subtract AmountSold from AmountBought to
come up with AmountInStock.

Thanks for any help

 

[MGFoster]

I have a table and three of the fields are AmountBought, AmountSold and
AmountInStock. In a query how do I subtract AmountSold from AmountBought to
come up with AmountInStock.

SELECT StockNumber, AmountBought-AmountSold As AmountInStock
FROM Inventory
WHERE ...

 

[David Cox]

in query design window:

AmountInStock: [AmountBought] - [AmountSold]