> All the records are from the same table, ...
True. But notice that the examples that I provided also referenced only one table. If you look
closely, you will see that I am querying the table twice. Once ( with the alias name "A" ) to find
your list of rows and once ( with the alias name "B" ) to find the running total.
> ... the letters were just row
> data.
Yes, I expected that you were simplifying you data in the example that you used. However, since
you were able to abstract you row data as single letters, conversely you should be able to extend
the example I provided to fit your table's design.
> So I should know the value of the row that is before the one I'm
> going to fetch ...
I do not understand you question here.
Regards,
Richard Broesma Jr.