counting field

[juanito2004]

Let's say I have 10 number fields in each record. I would like to create a field that counts how many times a value over 400 (for example) has been entered in those 10 number fields.

So if 2 of them are over 400 and the other 8 under, I would get a value of 2 in this new field.

Any help is much appreciated. I am still a beginner with this software.

[-Queue-]

(field1 > 400) + (field2 > 400) + (field3 > 400) + ... + (field10 > 400)

Replace > with >= if you meant 400 or greater. Each of the tests will be treated as a boolean and return either 1 or 0 (true or false), giving you a total of the number of fields for which the statement is true.