SELECT mytable
SCAN
FOR i=3 TO FCOUNT()
INSERT INTO newtable (no,name, fvalue) VALUES (mytable.no,mytable.name, EVALUATE(FIELD(i,mytable)))
ENDFOR
APPEND BLANK IN newtable
ENDSCAN
>mytable have fields as
>
>no name f1,f2,f4,f6 to....f65&& sometimes mytable have f1 to f56 aontehr time my table have only f1,f5,f8...etc
>1 ali 12 4 34 8
>
>i want new table as below if f1 ,f2,f4....found()
>
>no name f1
>1 ali 12
>.
>.
>empty record
>no name f2
>1 ali 4
>.
>.
>empty record
>
>no name f4
>1 ali 34
>.
>.
>empty record
>
>no name f6
>1 ali 8
>.
>.
>empty record
>
>thanks again
>.
>thanks
--sb--