I have a query where I have several Product Locations and I have Product Quantity Count
I am trying to get a total count of a product when it is found in multiple locations. I have had success with that part.
But if there is 0 product available it shows in the query blank but I want it to show 0 as in ZERO!
Here is my SQL for the original Query:
SELECT Products.ProductID, Sum(ProdLocations.QtyLoc) AS SumOfQtyLoc
FROM Products LEFT JOIN ProdLocations ON Products.ProductID = ProdLocations.ProductID
GROUP BY Products.ProductID;
and here is what I tried puting in the criteria for QtyLoc.ProdLocations Sum. This one says wrong number of Arguments:
and this one says Data Type Mismatch:
ProductID = Integer
SumOfQtyLoc = Integer
QtyLoc = Integer