Query to get total purchases and closing stock for period (1 Viewer)

raziel3

Registered User.
Local time
Today, 11:57
Joined
Oct 5, 2017
Messages
273
Good day,
My current setup:-

Products Table - UPC(Number), PNAME(Text)

Purchases Table - purDate(Date), PNAME(combo box), Quantity(Number)

Closing Stock - endDate(Date), PNAME(combo box), Quantity(Number)

I want to create a query that list all the PNAME from Products, Total Purchased and the Closing Quantity for each month end. On the following month end, the closing stock for the previous month will be the opening stock for that month.

The purchases occur throughout the month and we take the closing stock on the last day of every month. I tried using the query wizard and importing the PNAME from Products, Quantity from Purchases and Quantity from Closing Stock but I am only getting the totals for the Purchases and the Total for the Closing Stock is blank.
 

Users who are viewing this thread

Top Bottom