C
cthorne
I trying to create a report that uses an unbound field for 'Opening balance'
and gets it's data from the PREVIOUS record's 'Closing balance'. Please
note, this is not a running sum.....
Ex: Day Opening Closing
1 100
2 100 50
3 50 250
4 250 etc.
I'm currently using the Property setting - Control Source with the
expression
=[closingbalance]. This works, but uses the current record, not the
previous record's data.
Any help would be appreciated.
and gets it's data from the PREVIOUS record's 'Closing balance'. Please
note, this is not a running sum.....
Ex: Day Opening Closing
1 100
2 100 50
3 50 250
4 250 etc.
I'm currently using the Property setting - Control Source with the
expression
=[closingbalance]. This works, but uses the current record, not the
previous record's data.
Any help would be appreciated.