Query results

[bknight]

This query is from a Db I use daily. The results are not what I expected.

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"));

I was expecting a single sum and I see 10 "sums"

[Gasman]

1. Why do you have Fillled twice?
2. Not much to help with if we do not see the output?

I am going to guess that one or more of those fields are different?

[HansV]

Does this do what you want?

SELECT Sum(Trades.Dividends) AS SumOfDividends
FROM Trades
WHERE ((Month([filled])=3) AND (Year([filled])=2024) AND ((Trades.Type)="Dividend"));

[bknight]

Does this do what you want?

SELECT Sum(Trades.Dividends) AS SumOfDividends
FROM Trades
WHERE ((Month([filled])=3) AND (Year([filled])=2024) AND ((Trades.Type)="Dividend"));

Yes it does, thanks