Folks, How does one replicate the equivalent of the Oracle LAG function? Basically I need to calculate the difference between a specific field in a row and the same field in the previous row, e.g. the difference between dates
Folks, How does one replicate the equivalent of the Oracle LAG function? Basically I need to calculate the difference between a specific field in a row and the same field in the previous row, e.g. the difference between dates
Not sure if this will help, but I had a problem a while back where I needed to refer to records above and below the current record to count employee RF transactions.
https://www.accessforums.net/queries...elow-8134.html
Access doesn't have Analytic functions like Oracle.
You could probably design some custom functions in vba.