View Single Post
  #1 (permalink)  
Old September 13th, 2006, 06:57 PM
needelp needelp is offline
Authorized User
 
Join Date: Sep 2006
Location: , , Australia.
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default Getting Part of a String

Hi all,

i was wondering if it was possible to grab a part of a string
eg.
i have an order number that is displayed as a string eg. "06-1234"
what i wish to do is, when a new record is entered select the "1234" part of the string from the previous record, convert it to a number (i think like a Cint() type thing) increment it by 1 then convert it back to a string and put back the "06-" and put it in the new record..

i hope that makes sence

any help or advice would be much appreciated

cheers

Reply With Quote