String Help

[scott]

I have a string like 1.0.1 that I need to increase the last digit to 1.0.2
for example.

How can I isolate the last digit after the 2nd period in a string like
"1.0.1"?

 

[Ken Snell \(MVP\)]

LastDigit = Right("1.0.1", Len("1.0.1") - InStrRev("1.0.1", "."))

 

[Jeff L]

Right(YourValue,1) will give you the last digit

 

[kingston via AccessMonster.com]

eval(mid(string,instr(instr(1,string,".")+1,string,".")+1) + 1)

 

[John Vinson]

I have a string like 1.0.1 that I need to increase the last digit to 1.0.2
for example.

How can I isolate the last digit after the 2nd period in a string like
"1.0.1"?

I presume you would also want 3.24.109 to increment to 3.24.110?

Note that you may want to consider using three Integer fields rather
than one composite text field.

John W. Vinson[MVP]

 

[scott]

Thank you.

LastDigit = Right("1.0.1", Len("1.0.1") - InStrRev("1.0.1", "."))