Hi,

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!