InStr() - Help with query

[mralmackay]

Hi,

Is it possible to do the following @ all. I need to query a field
called DiaryEditor within table Extract for the next two words after
any occurence of the following "Updated By: ". I understand that the
InStr() function could be used but not quite sure how this is meant to
be used in this example.

TIA for your help with this.

Al.

 

[Ed Metcalfe]

Hi,

Is it possible to do the following @ all. I need to query a field
called DiaryEditor within table Extract for the next two words after
any occurence of the following "Updated By: ". I understand that the
InStr() function could be used but not quite sure how this is meant to
be used in this example.

TIA for your help with this.

Al.

Assuming there are no other words after "Updated By: " something like this
should work:

Right([Extract].[DiaryEditor],len([Extract].[DiaryEditor])-instr(1,[Extract].[DiaryEditor],"Updated
By: ")-11)

Ed Metcalfe.

 

[mralmackay]

Thanks for your help with this Ed, will try this tomorrow.

Thanks, Al.

Hi,

Is it possible to do the following @ all. I need to query a field
called DiaryEditor within table Extract for the next two words after
any occurence of the following "Updated By: ". I understand that the
InStr() function could be used but not quite sure how this is meant to
be used in this example.

TIA for your help with this.

Al.

Assuming there are no other words after "Updated By: " something like this
should work:

Right([Extract].[DiaryEditor],len([Extract].[DiaryEditor])-instr(1,[Extract­].[DiaryEditor],"Updated
By: ")-11)

Ed Metcalfe.