Reference from Relative Position in a Query
In Queries, it would be nice to be able to reference a value in a record relative to the current one.
For instance, many times it is required to get a difference in a changed value
It was suggested to have a CurrentRecord ability for conditional formatting. Expanding on this for queries, LastRecord would be nice.
For instance ... Difference: [myField] - LastRecord.[myField]
This would depend on the order that records are displayed.
This would also give us the ability to report Running Sums.
For instance... SubTotal: IIF([myGroup]=LastRecord.[myGroup], [myField] + LastRecord.[SubTotal], [myField] )