You can use EVALUATE() function

mynumber = mynumber + SUBSTR( EVAL(FIELD(gnCountS)),3) + SPACE(5)

>To be able to get the fields after using the cross tab query.
>FOR gnCountS = 1 TO FCOUNT()
> mynumber=mynumber+SUBSTR(FIELD(gnCountS),3)+SPAC(5)
>NEXT
>My problem is how to get value of each fields per record table and put the value to a variable? please help...
>
>Mike