I'm assuming these fields are numeric, in which case you could create a new field for every triplet and then Sum() the values:
Field ChildSum_n+1:
Sum([Child 1], [Child 2], [Child 3])
Then you can just summarize the ChildSum_n+1 results in a new field:
Average([ChildSum_0], [ChildSum_1], [ChildSum_2], ...)
Makes sense?
Hey Lordsman
When you say to create a new field for every triplet, do you mean the child records? They could be dozens to hundreds of them so tons of fields doesn't sound like a good idea... haha. Or, did I misunderstand?
