I assume that the "fields" are actually a set of records with the data always in the same field but in different records?
If so, this is another "sum if" problem where we want to sum a value in a set of records only if a value in another field has a specific value.
- This can be done by summing related records where the relationship matches only to the desired set of records.
- This can be done with a summary report where a find pulls up the desired found set of records and a sort groups them. A subsummary layout part and a summary field can then produce the needed sub totals.
- A filtered portal can filter for just the desired subset of the related records and a summary field from the portal's table can then show the total
- ExecuteSQL() can also return such values.
I think #1 option would work in this case. Just throwing around ideas. I dont know if you gave me this on another occasion or not. I've never used the Executive SQL and have no idea what it is. I'll try the Sum and see. Thanks Phil as Usual