Skip to Content
Mar 24 at 03:11 PM

Query monthly sales displayed by month

157 Views Last edit Mar 23 at 10:01 AM 2 rev


i am looking for a Query that will show all of our items and the amount sold in orders displaying the result by month.

I would also like to know the stock at the time of using the query and the minimum stock if there is.

So, header would be...

Item #...Jan Qty...Feb Qty...Mar Qty...etc... In Stock... Minimum stock

Does anyone know a Query that can do this?