Avatar

Level 10

FormCalc is very useful for this type of work. You can use an * as a wildcard when addresing fields and it will perform the operation on all fields that match. So for the total you can use Sum(rowTotal[*]) and it will add all instances of the fields called rowTotal.

Paul