>Thank you Vladimir,
>
>It worked fine after testing your code, is it possible to do with
>SQL statment only ?
Yes, but only with VFP9
SELECT cOdd.Field AS Amount1,;
NVL(cEven.Field,"") AS Amount2 ;
FROM (SELECT recno() AS pk, Field FROM mytable WHERE recno()%2=1) cOdd;
LEFT JOIN (SELECT recno()-1 AS pk, Field FROM mytable WHERE recno()%2=0) cEven ON cEven.pk =cOdd.pk;
INTO Table NewTable
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst