Thanks so much Richard. I made sure this was set correctly - I was pretty hopeful this would do the trick - but it wasn't to be. Terry On May 12, 2011, at 5:47 PM, Richard S. Russell wrote: > Whenever I get sporadic or puzzling results like this on a > CALCULATION field, I usually go into the definition of the > calculation and make sure that the point of origin is indeed the > table I want. It's at the very tip-top of the "Specify Calculation" > box, labelled "Evaluate this calculation from the context of: [drop- > down menu]".