qrySalesCount counts products sales (the FO part of FIFO):
SELECT T1.ProductID, tblProduct.ProductName, T1.OrderID, tblOrder.OrderDate, T1.Quantity, T1.UnitCost,
(SELECT Sum(tblOrderDetails.Quantity) AS Total FROM tblOrderDetails
WHERE tblOrderDetails.OrderDetailsID <=...