I have a query that i want to get the total amounts for debits and credits. (See image)
however i need to limit the totals to one year. When i add the date range using a between statement in the criteria i get the totals for each date which is not what i need. I have tried several methods and it get the same result. How can i limit the data
to the date range i want and get just the totals for credit and debit?