Query for maintaining Stock of Product
Advanced Beginner
Windows 7 64bit 
Access 2010 64bit
I am trying to create stock query to maintain stock of my product, following image shows my table structure and what i have tried.
My Query Result in this image which is not i trying to get:
what i am trying to do is.
(1) How much Quantity of perticular product i have purchased?
(2) How much Quantity of perticular product i have Sold?
(3) How much Quantity of perticular product i have in my hand(in stock)?
what does i doing wrong pelase guid me.
Download ACCESS DATABASE
Access Developer
Windows 7 32bit Access 2003
Try creating another column which does the calculation purchases-sold.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Advanced Beginner
Windows 7 64bit Access 2010 64bit
Result shows in the image is not true
quantity shows in image is wrong so i requires some suggestion.
Also see i have attached Access Database Link for clear idea.
Access Developer
Windows 7 32bit Access 2003
Take a look at the attached db. I have amended your query to give the results that I think you want.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Selecting Product from combo box of subform adding new product in product table.
Posting Permissions
Reply With Quote