Query to calc balance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
CoachBarkerOJPW said:
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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query result to table 4
Access Running Balance in Access 1
Remaining Balance Query 2
multiple calcs in a query 2
Running Balance in Access 2007 5
Balance Query 10
Query Calculations & 2
Balance Comparison Query 2

Back
Top