Help with Right(Me.ListStoreIP.Column(0), 2)
Looks like it moves the start position one space to the right of the # so it
should return everything to the right of the # sign. Does it?
"Mike" wrote:
Thanks Joel
Can I ask whats the +1 do
"Joel" wrote:
mid(mystring,instr(mystring,"#") + 1)
"Mike" wrote:
I think there is a way to find # and use the value to the right of the number
sign
Any help would be great
Tobacco Rd Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #112
Right(Me.ListStoreIP.Column(0), 2) = 12 Wrong
|