1 Reply Latest reply on Jul 17, 2018 4:13 PM by Ken Flerlage

    How to use next record in custom sql to create a new field

    Guillaume OBSER

      Hello,

       

      I've a connection on DBF files via Access.

       

      To merge two tables, I need to create a new field in custom sql. The new fields would be the next record from the "SALAI_HI.SI_DATCHA as Debut_salaire" field.

       

      Thank to that, I would have a startdate and a finish date for every period of each user.

       

      For now, I can't find a way to create this new field...

       

      Any Idea ?

       

      Thank you in advance :-)