np,
On a summary report, you can suppress the totals at the bottom as there is a checkbox setting for that on the report for that.
Ah but now you have Part B to the question that you want to use the running totals in report or in other formulas, that is a more difficult question.
The only way to do that really would be to Create a relationship between the Child table YEAR records and themselves. Quick Base allows that. The main thing to worry about there is the proper naming of he fields so you don't get your self confused.
The issue will be how to connect the records so each child know which other record was its parent previous year. ie how to make the daisy chain without breaking the connections.
That can be done manually as you add a new child YEAR record, or it may be possible to create a Key field which is a concatenation of the [Related Parent] and the YEAR and have them link up automatically.
To do that you would need to make a formula field to calculate that, then populate that into a data entry type "scalar" field and then change the Key field of the Child record from [Record ID#] to this new field. Then going forward you would have a form rule populate the scalar Key field with the value on the Key field formula field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
