Trouble with NOT 1

[molly]

I have a Qry criteria problem. There are 3 possible answers in a number field in the qry. the field can be one of the following: Null, 99, 112 or 181 answer.

I want to get everything except 181. i unsuccessfully used 3 ways:
<>181 and tried NOT 181 and tried Not IN (181)

i want to just use the one exclusion which is 181.

any ideas? thanks

 

[PHV]

<>181 Or Is Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[molly]

Thanks alot. It worked.

 

[PWise]

i use nz(Fieldname,0)<>181