Strange behavior of query

[bknight]

Hey guys I have a strange behavior in an otherwise normal query

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

You'll notice that Jun 22 is blank and yet there is a record on 6/6. Any thoughts?


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;

[HansV]

We cannot see Trades.Type in your screenshots.

[bknight]

Ok. Dividends is the far right field(not shown)

[bknight]

Never mind I just saw the problem, sorry for the inconvenience.

[HansV]