Oracle LAG Equivalent

[OzzyMiner]

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

[William McKinley]

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

[orange]

Access doesn't have Analytic functions like Oracle.
You could probably design some custom functions in vba.