It is only sample data I have put in, so can add more data to get the running total.
Where would I add the "product" to the summing criteria for it to group by "product"?
RunningSum: Sum((Select Sum([QtyAdjusted]) from [QCombinedInventory] as a where a.[Timeadjust]<=[QCombinedInventory].[Timeadjust]))
Where would I add the "product" to the summing criteria for it to group by "product"?
RunningSum: Sum((Select Sum([QtyAdjusted]) from [QCombinedInventory] as a where a.[Timeadjust]<=[QCombinedInventory].[Timeadjust]))