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

ChrisMore

Member
Local time
Today, 05:27
Joined
Jan 28, 2020
Messages
97
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: 25

jdraw

Super Moderator
Staff member
Local time
Today, 00:27
Joined
Jan 23, 2006
Messages
13,482
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, 05:27
Joined
Jan 28, 2020
Messages
97
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, 00:27
Joined
Jan 23, 2006
Messages
13,482
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