Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
BOM Chart - Date | Balance | Change | BOM Chart - Cumul |
07/12/2009 | 311580 | 0.00 | -121440 |
09/12/2009 | 311580 | -21600.00 | -121440 |
11/12/2009 | 289980 | -21600.00 | -99840 |
16/12/2009 | 268380 | 0.00 | -78240 |
20/12/2009 | 268380 | 0.00 | -78240 |
22/12/2009 | 268380 | 0.00 | -78240 |
27/12/2009 | 268380 | 0.00 | -78240 |
Easiest would be to reload the table in DESC-sortorder and then to use the PEEK-function.
HTH
Peter
What about something like Peek('field',RowNo(),'table')?
Since peek expects a 0 for the first row, you don't have to add 1 to the RowNo() to get the next row after the current one.
I haven't tried this myself
Do not think that there is much of a difference, if you look ahead by your method or look one record back in a table, which is sorted in a descending order. Might be worth to give it a try...
Peter
Have you tried using the "below" function? I use the "above" function to retrieve the prior months figure so that I can compare it to the current months figure.