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 :-)
In SQL Server, you can use a function called LEAD to get a value from the next row. LEAD (Transact-SQL) | Microsoft Docs But I'm not sure that would work with DBF/Access. Any way to get this data into another database such as SQL Server?