>Dear All,
>I know it sounds crazy but how can make a conversion such as this one
>instead of typing the following will it be possible to do it in a loop
>Thanks to all
>
>If fieldz =7 replace fieldz WITH 97
>If fieldz =6 replace fieldz WITH 84
>If fieldz =5 replace fieldz WITH 74
>If fieldz =4 replace fieldz WITH 59
>If fieldz =3 replace fieldz WITH 50
>If fieldz =2 replace fieldz WITH 34
>If fieldz =1 replace fieldz WITH 24

I don't see a common formula to make these 7 numbers. IMHO, it's easy to type.