New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
SELECT tblProducts.ProductID, tblProducts.ProductName, Sum([qryStockCount].[InStock]+[qryStockReceived].[QtyRec]) AS QtyOnHand FROM qryStockReceived INNER JOIN (tblProducts INNER JOIN qryStockCount ON tblProducts.ProductID = qryStockCount.ProductID) ON qryStockReceived.ProductID = tblProducts.ProductID GROUP BY tblProducts.ProductID, tblProducts.ProductName;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.