Strings

[**KP**]

I posted this earlier and may have posted in wrong group.

Hi,

I have a table with text data in Field1. In some cases
Field1 contains the value "VENDOR NUM". I want to use an
Access DB Module Function and search for the record(s)
with "VENDOR NUM" in it. Once I find the record, I'll use
the Left() and Right() Function to extract a certain # of
characters from Table2!Field2 and place elsewhere in
Table2. I'm using the following but can't get it to work
for nothing:

If Table1!Field1 Like "*VENDOR*" Then

I'd really appreciate any help you could give me on this
issue. Thanks in advance.

 

[Douglas J. Steele]

Try:

If InStr(Table1!Field1,"VENDOR") > 0 Then

 

[**KP**]

One other question. Isn't there a function for starting in
a particular position within a string and returning a
specified # of characters? For example: ReturnDesc = str
(field, startposn, #chars to retrieve). I've seen it
before but can't find in in my Access resources. TIA

 

[Dirk Goldgar]

One other question. Isn't there a function for starting in
a particular position within a string and returning a
specified # of characters? For example: ReturnDesc = str
(field, startposn, #chars to retrieve). I've seen it
before but can't find in in my Access resources. TIA

That's the Mid() function. You'll find it in the VBA online help.
Unfortunately, that's only available when you're working in the VB
editor.