is there reverse instr function in microsoft access

A

Amjad

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
 
C

Cheryl Fischer

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
 
A

Allen Browne

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
 
G

Gerald Stanley

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
 
Top