Adding Summary fields
Have three (running total) summary fields to add. (Sum1= SumA + SumB + SumC).
(The summary fields, SumA, SumB, and SumC have correct values.)
Sometimes Sum1 has the right answer,sometimes not. Have tried defing Sum1
as a number field with a calculation, have tried a calculation field (both global
and non-global) and yet nothing gives a consistent answer. Would appreciate help.