Hello,

I have a series of calculations within a record that will most often result in a number, so I have defined the calc fields to be a number result. But occasionally the result will be a single letter (text).

I need to do arithmetical calculations (such as a sum the fields) on the result where it is a number, which would need to ignore any of the results that were a letter.

And I would need to do a count of the number of occurences where the result was a letter.

Would some kind soul be able to give me a little guidance on how I should deal with this?

Thanks very much.

(In case it may be suggested, defining any more fields such as 'if/then' type calculations to try to reorganise the data is not a practical solution because of the number of fields involved.)

Check out the "TextToNum" function for calculations.

To read about it, open the Online Help, go to Index, and type in

TextToNum function and then hit Display button.

HTH

Lee

I'm a little(?) confused.

Do you have three levels? Are you doing calcs on calcs, some of which can be alpha? Or just doing calcs on fields?

Are the basic fields alpha or numeric? If three levels, what type are the intermediate levels?