design query match anywhere?

  • Thread starter Thread starter Nooby
  • Start date Start date
N

Nooby

In the design query 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!
 
Are you saying you put that InStr bit as a criteria under your Description
field in the query designer? Try putting

Like "*ABC*"

as the criteria instead.

Alternatively, you could add a computed field to the query

InStr([Description, "ABC")

and then put >0 as the criteria for that field.
 
Are you saying you put that InStr bit as a criteria under your Description
field in the query designer? Try putting

Like "*ABC*"

as the criteria instead.

Alternatively, you could add a computed field to the query

InStr([Description, "ABC")

and then put >0 as the criteria for that field.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)




In the design query 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
Click to expand...
How else can I match ABC (upper and lowercase) to anywhere in my
'description' column?
Thanks!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Excellent. Now I realize why the design wizard kept moving the Instr
to the top of the next column. I did not understand that. Thanks! Sam
 
Back
Top