is there a previous or next function with vb syntax

[espltd]

HI I am using vb syntax just wondering if there is a previous or next function equivalent as to the crystal syntax? thanks.

 

[BParsons]

Are you looking for these;

PreviousValue(field) and NextValue(field)?

 

[espltd]

Hi thanks yep that was what I was looking for. trying to figure out how to look ahead that is if the data for the column is
3
3
3
I need my formula to add on a -number so it looks like
3-03
3-02
3-01
not sure if I can do this with a formula.