Question

Access 2016, how do I do a query to find out quantity in stock and the unit price and what the value is for each item?

Answer 1

In Access, to find out the quantity in stock, unit price and value, we can write the SELECT query as below:

SELECT quantity, unit_price, value FROM Item;

Here, it is selecting quantity, unit price and value from the table Item. The name of columns and table might get change as per the actual schema of table.

Name assumptions:

• quantity is the name of column in table representing the quantity of the respective Item.
• unit_price is the price of each unit of the Item.
• value is the value of Item
• Item is the name of table having the data

Please change the above name of columns and table if required.

Let me know if you have any questions.

Thanks!