Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

is there a previous or next function with vb syntax

Status
Not open for further replies.

espltd

Programmer
Apr 6, 2005
233
US
HI I am using vb syntax just wondering if there is a previous or next function equivalent as to the crystal syntax? thanks.
 
Are you looking for these;

PreviousValue(field) and NextValue(field)?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top