Search results

But the on hand is basically the amount of items they have in stock, So i think the question is asking me to average the amount of item that is in stock by the supplier code. I finally got it . Thank you guys

i am still trying to understand the question my self, despite reading how to sum data by query. But initially the question ask me to create a query showing the inventory value by (on hand * cost) which is displayed in the pic below. The second question is asking for me to create a query that...

Thank you, One more question as it relates to the same data but a different query. I am unsure of how to do this question . Create a query that calculates and displays the average items On Hand in inventory by Supplier Code. Select the following fields for the query; Supplier Code, On Hand...

Hi, I am having issues with the criteria for the query. The instructions are as follows Display all fields for all products with a selling price greater than $10.00 and the number on hand is fewer than 10 Sort the query in ascending order according to the Cost field. Save this query as...

My name is teemax, I am currently new to Microsoft access and I am from Jamaica.