Code: Select all
SELECT Int(([NinjaTrader2024].[Time])) AS TradeDate, Sum(NinjaTrader2024.Profit) AS TotDaily, Sum(Abs([quantity])) AS Trs, Sum([commission])+Sum([fees]) AS [Com&Fee], NinjaTrader2024.NumRec
FROM NinjaTrader2024
WHERE (((Int(([NinjaTrader2024].[Time])))>=Date()-Weekday(Date())+1 And (Int(([NinjaTrader2024].[Time])))<Date()-Weekday(Date())+8))
GROUP BY Int(([NinjaTrader2024].[Time])), NinjaTrader2024.NumRec, NinjaTrader2024.NumRec
HAVING (((Sum(NinjaTrader2024.Profit)) Is Not Null));
Code: Select all
SELECT quTradeRunningSumProfit.*, Val(DSum("Profit","quTradeRunningSumProfit","NumRec<=" & [NumRec])) AS RunningSum
FROM quTradeRunningSumProfit;