>The format of my control is numeric, it works if I don't don't put any digits in the format part of the control. Except I get 4 numbers after the decimal point. If I change it to currency, I get the CR for the control. I have made the control and the number of digits quite large. The only way it works is if it is numeric or character. Once I put in the number of digits it doesn't work. I am putting in 9999.99 This is large enough for what I need and I only want two decimal places not four. Do you know why any of this is happening?
>
Try performing your average operation on the MTON() of the currency field - this will convert the currency data type into a numeric. You may be running into problems with the fixed precision and sizing of currency computations (use of the currency data type in a computation force the result into the currency data type) and using the MTON() may work around this.
With addition/subtraction, precision is not a major problem, but in order to compute an average, there's division involved...