Calculation Query

[jimd1768]

I have an inventory database and I would like to run a query that shows the value of stock I hold.
I have not added the cost per item in the database. This is what I have:

Item
Current Stock level

I now want to add:

Cost of Item
Total Value of Stock (Current Stock * Cost)

Because I don't have the cost of item in a table anywhere, Is it still possible to create this query?

All help would be greatly appreciated.

 

[MStef]

Try and see.

 

[jimd1768]

Try and see.

Thank you for your response.
I have tried and cannot get a result. That was why I posted the question.

Thanks

 

[DCrake]

If you have individual stock items in your stock table and a unit cost price (with a value in it) and the quantity in stock you can create a query that will multiply the unit cost price by the stock level to get the total value of each item of stock

You can then create another query that will sum the total stock value in the above query to get the grand total of value of all stock.

But remember you will have a purchase price (what you pay for it) and a selling price (What you sell it at) this may be markup or margin. Don't know your logic.

 

[jimd1768]

Thank you David. My issue was that I had not created a field that showed item price. I have now created a table to hold that data and the query now works.

Thank you for taking the time to respond.