Code: Select all
SELECT (Year([Filled])) AS [Year], (Month([Filled])) AS [Month], Sum(Trades.Dividends) AS Dividend
FROM Trades
GROUP BY (Year([Filled])), (Month([Filled])), Trades.Type
HAVING ((((Year([Filled])))=2022) AND ((Trades.Type)="Dividend"));
The othere list query is
Code: Select all
SELECT Trades.Symbol, Trades.Filled, Trades.Entered, Trades.Dividends
FROM Trades
WHERE (((Trades.Dividends)<>0))
ORDER BY Trades.Filled DESC , Trades.Entered DESC , Trades.Symbol;