3 Replies Latest reply: Dec 30, 2009 1:40 PM by Jean-Jacques Jesua RSS

    Get the next value

    Jean-Jacques Jesua

      Hi,

      I read a file with the script.

      For each record, I created a new field with the previous value :

      Previous( myField ) as Prev_Field

       

      My question is how to create another field with the next value ?

      I tried Fieldvalue ( 'myField' , recno() + 1) but without success. Any ideas ? Of course my file is well-sorted.

      Thanks very much for your help.

      Jean-Jacques