Position Of A Character In A String

Ste4en

Registered User.
Local time
Today, 21:17
Joined
Sep 19, 2001
Messages
142
If I have 13C124 I want to return 3, the position of the C. 1C12345 would be 2.

What is the function to do this.
Thanks
 
The InStr() function.

Late versions of Access (A2000+) also have InStrRev() for retrieving the position from the right of the string.
 
thats what I needed,
thanks
 

Users who are viewing this thread

Back
Top Bottom