Hi,

I have to assign string "NO" to a number field 'OfficialIndex' if the value is >= 32767 else I have to divide 'official index' by 10. when I code
If not ({dbplayers.officialindex} = 32767) then {dbplayers.officialindex}/10 else "NO"

it gives a syntax error saying a number is required in place of "NO". How can I assign this string to the field?

Thanks

try this
If not ({dbplayers.officialindex} = 32767) then
totext({dbplayers.officialindex}/10)
else "NO"

It worked!
Thanks Kondapally.

no prob.Any time.
Kavitha.