Code: Select all
SELECT Sum(Trades.Dividends) AS SumOfDividends
FROM Trades
GROUP BY Trades.Filled, Trades.Filled, Trades.Type, Trades.Symbol
HAVING ((Month([filled])=3) AND (Year([filled])=2024) AND ((Trades.Type)="Dividend"));
Code: Select all
SELECT Sum(Trades.Dividends) AS SumOfDividends
FROM Trades
GROUP BY Trades.Filled, Trades.Filled, Trades.Type, Trades.Symbol
HAVING ((Month([filled])=3) AND (Year([filled])=2024) AND ((Trades.Type)="Dividend"));