I have a table Pic3Tb, with 3 fields: ID, Date, and Result I want to make a query with a new column that shows the difference between the same result, from the current and last day. In excel i just to use Match Funtion.
Pic3 table
Id Date Result Last (ideal result)
1 05/01/21 130 0
2 06/01/21 150 0
3 07/01/22 150 1 Date (Id 2) - Date(Id 3)
4 08/01/21 130 3 Date (Id 1) - Date(Id 4)
5 09/01/21 162 0
6 10/01/21 562 0
7 11/01/21 162 2 Date (Id 5) - Date(Id 7) and so on...
Help Please!!!