Query

[Gazmysta]

Hi, Just wondering if anyone can help? Im tryin to work out the total value of stock we have using a query on a table e.g

Quantity Price
62 4.95
12 3.00
43 6.72

How much stock value we have?

Thanks

 

[Norris68]

SELECT SUM(Quantity * Price) AS StockValue FROM MyTable

To list the value per stock item,

SELECT ItemID, SUM(Quantity * Price) AS StockValue FROM MyTable GROUP BY ItemID

 

[Gazmysta]

Thank you!