Return Quantity on Hand for all products at the same time (1 Viewer)

ChrisMore

Member
Local time
Today, 23:41
Joined
Jan 28, 2020
Messages
174
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
 

Attachments

  • Inventory Database.zip
    172.5 KB · Views: 154

jdraw

Super Moderator
Staff member
Local time
Today, 19:41
Joined
Jan 23, 2006
Messages
15,364
Chris,

Try this query. It's a modification to your Quantity_On_Hand_All_Products_Query
Code:
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

Member
Local time
Today, 23:41
Joined
Jan 28, 2020
Messages
174
Try this query. It's a modification to your Quantity_On_Hand_All_Products_Query
Code:
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

Super Moderator
Staff member
Local time
Today, 19:41
Joined
Jan 23, 2006
Messages
15,364
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.
 

Users who are viewing this thread

Top Bottom