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]".