The following query should filter for dates between 1/1/23 and 12/31/23 but lists all values as shown in the anonymized spreadsheet which was exported. The query was built in the UI.
Code:
SELECT tblTransactions.Payee, Sum(tblTransactions.Deposits) AS SumOfDeposits, tblTransactions.TypeTrans, tblTransactions.TranDate
FROM tblTransactions
GROUP BY tblTransactions.Payee, tblTransactions.TypeTrans, tblTransactions.TranDate
HAVING (((Sum(tblTransactions.Deposits))>0) AND ((tblTransactions.TypeTrans) Like "Div*") AND
((tblTransactions.TranDate) Between #1/1/2023# And #12/31/2023#)) OR (((tblTransactions.TypeTrans) Like "Int*"));