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



      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 :-)