Account balances – summarized data rather than transactions
29 January, 2016
We have daily account balances:
[code]
Account Date Opening Balance Closing Balance
------- ----- --------------- ---------------
Mary Jan 1 5 10
Mary Jan 2 10 25
Mary Jan 3 25 0
[/code]
And would like to select a date range, e.g. Jan 1 - Jan 5 and see the opening and closing balance:
[code]
Account Opening Balance Closing Balance
------- --------------- ---------------
Mary 5 0
[/code]
Any tips or hints?
Thanks!