syntax for query criteria

[dumdum2]

I have an expression in a query that I hoped would pull records that include 'pw' (as a whole) in the displ_sub field, but my expression pulls records that only have a 'p' in the displ_sub field....I thought by using the quotes around "pw" would do the trick.....?

Expr1: InStr("pw",[displ_sub])

Thanks!

 

[PHV]

And what about this ?
Expr1: InStr([displ_sub],"pw")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

You have your arguments reversed

Expr1: InStr("pw",[displ_sub])

says Find occurences of [displ_sub] in "pw"

You need

Expr1: InStr([displ_sub],"pw")

i.e. Find occurences of "pw" in [displ_sub]