Hi everyone,
I am new to this forum and hoping for some assistance.
I have very little knowledge of VBA in Access and am currently developing a stock database. I plan to have a report which summarizes all products showing key information, such as the current quantity on hand levels. I have everything ready to go but the function I am using only returns one product's on hand level at a time using a parameter.
I used Allen Browne's Inventory Control: Quantity on Hand article and adjusted the function to suit my table names. It works perfectly and returns the on hand quantity as it should. However, what I really need is for the function to return the quantity on hand for all the products at the same time, instead of just one. I have structured my database in the same way as the example in Allen Browne's article.
My table names are as follows:
Products
Customer_Orders
Customer_Orders_Items
Purchase_Orders
Purchase_Orders_Items
Stocktake
I would really appreciate some help to get this working.
Thank you very much in advance
Chris
I am new to this forum and hoping for some assistance.
I have very little knowledge of VBA in Access and am currently developing a stock database. I plan to have a report which summarizes all products showing key information, such as the current quantity on hand levels. I have everything ready to go but the function I am using only returns one product's on hand level at a time using a parameter.
I used Allen Browne's Inventory Control: Quantity on Hand article and adjusted the function to suit my table names. It works perfectly and returns the on hand quantity as it should. However, what I really need is for the function to return the quantity on hand for all the products at the same time, instead of just one. I have structured my database in the same way as the example in Allen Browne's article.
My table names are as follows:
Products
Customer_Orders
Customer_Orders_Items
Purchase_Orders
Purchase_Orders_Items
Stocktake
I would really appreciate some help to get this working.
Thank you very much in advance
Chris