Can a field be set to retrieve the previous balance?
I have a small school.
30 students each pay monthly for a year.
I would like to have a field that will show the previous month's balance.
For instance...if last month, a student paid less than their scheduled amount, I would like to show this on the next record, as part of the record.
So, this new month, there would be the field showing the previous month's balance.
Seems easy, but I just can't get it. Any help is greatly appreciated.