design query grid match anywhere question

N

Nooby

In the design query grid I want to match the letters "ABC" anywhere in
the
column 'description'. I could not get instr to work by using:
InStr(description, "ABC")) > 0

How else can I match ABC (upper and lowercase) to anywhere in my
'description' column?
Thanks!
 
N

Nooby

In the design query grid I want to match the letters "ABC" anywhere in
the
column 'description'. I could not get instr to work by using:
InStr(description, "ABC")) > 0

How else can I match ABC (upper and lowercase) to anywhere in my
'description' column?
Thanks!
Click to expand...

Like "*ABC*" Thanks!
 
M

Marshall Barton

Nooby said:
Like "*ABC*" Thanks!
Click to expand...


The Instr will do that, but you need to use it as a
calculated field:

Field: InStr(description, "ABC")
Show: unchecked
Criteria: >0
 
Top