Access 2003

#1

I want to within a field on a table find a char and its location. Then
I can move left or right and collect the data. This can easily be done
in Excel - in Access Like will find the record but not the position.
Any ideas folks.

#2

Barry wrote:

Quote:

I want to within a field on a table find a char and its location. Then
I can move left or right and collect the data. This can easily be done
in Excel - in Access Like will find the record but not the position.
Any ideas folks.

Would Instr() help?

? instr("Barry","r") 'forward
3
? instrrev("Barry","r") 'backward
4

#3

On 09/03/2011 18:45:04, Salad wrote:

Quote:

Barry wrote:
I want to within a field on a table find a char and its location. Then
I can move left or right and collect the data. This can easily be done
in Excel - in Access Like will find the record but not the position.
Any ideas folks.

Would Instr() help?

?
3 i
? instrrev("Barry","r") 'backward
4

Don't forget this will only find the first instance of the letter eithr from
the back or front. dim X as integer
X = instr("Barry","r") finds the first occurrence
X = instr(X+1, "Barry","r") finds the next occurrence
Phil

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access 2003

comp.databases.ms-access comp.databases.ms-access

Access 2003 - 03-09-2011 , 11:34 AM

Re: Access 2003 - 03-09-2011 , 12:45 PM

Re: Access 2003 - 03-09-2011 , 01:58 PM