S Ste4en Registered User. Local time Today, 21:17 Joined Sep 19, 2001 Messages 142 Aug 10, 2004 #1 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
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
Mile-O Back once again... Local time Today, 21:17 Joined Dec 10, 2002 Messages 11,305 Aug 10, 2004 #2 The InStr() function. Late versions of Access (A2000+) also have InStrRev() for retrieving the position from the right of the string.
The InStr() function. Late versions of Access (A2000+) also have InStrRev() for retrieving the position from the right of the string.
S Ste4en Registered User. Local time Today, 21:17 Joined Sep 19, 2001 Messages 142 Aug 10, 2004 #3 thats what I needed, thanks