Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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;
Join the community of 500,000 technology professionals and ask your questions.