is there reverse instr function in microsoft access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi i want to find a charactor in a field but i dont want to start serach from start i want to find it from en
like in vb you can do that thing by instrrev fucntio
thanks
 
I do not believe it is in all versions of Access, but you might want to
check out the InStrRev() function.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Amjad said:
hi i want to find a charactor in a field but i dont want to start serach
Click to expand...
from start i want to find it from end
 
InstrRev() is present in Access 2000 and later.

In A97 and earlier, you can roll your own by looping backwards through the
string to search for the character(s).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Amjad said:
hi i want to find a charactor in a field but i dont want to start serach
Click to expand...
from start i want to find it from end
 
According to the Help File, instrrev is a valid function.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
hi i want to find a charactor in a field but i dont want
Click to expand...
to start serach from start i want to find it from end
 
Back
Top