Return Quantity on Hand for all products at the same time

[ChrisMore]

Chris,
Can you post your latest database with the revisions you have made?

jdraw,

I have attached the database. The 'Quantity_On_Hand_All_Products_Query' is the one with the custom function.

Thanks for your help,
Chris

 

[jdraw]

Chris,

Try this query. It's a modification to your Quantity_On_Hand_All_Products_Query

SELECT Products.Product_Code
, OnHand(Product_Code) AS [On Hand Quantity]
FROM Products;

You need to call Allen Browne's OnHand function. That's what I was doing in the InvtyAllProds.
Good luck

 

[ChrisMore]

Try this query. It's a modification to your Quantity_On_Hand_All_Products_Query

SELECT Products.Product_Code
, OnHand(Product_Code) AS [On Hand Quantity]
FROM Products;

Thank you so much, jdraw, that has solved my problem. It looks to be a really simple solution as well. But, of course, it's only simple when you know.

I can now progress with my project!

Cheers,
Chris

 

[jdraw]

You are very welcome Chris. Happy to help.
There are several articles in this link that may be useful or at least serve as reference as you proceed with database and vba.