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.

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


"Nooby" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>

On May 24, 2:32 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> 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!)
>
> "Nooby" <stwil...@writeme.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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!- Hide quoted text -
>
> - Show quoted text -

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