Help excluding various records from query need expression for criteria

[fish2]

I have looked at other threads regarding this and I cannot seem to find one that is helping me....Please help

Query looks like this:

Member ID
Name
Class

I need to exclude certain "class" records specifically 80,90,86. What expression do I use to set this criteria.

Thanks in advance for anyone's help!!!!!!!!!!!!

 

[PHV]

Not In(80,90,86)

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

 

[fish2]

It came up with the following error:

"Data type mismatch in critreia expression"

There are 80, 90, 86 classes????

 

[PHV]

If the field is not defined as numeric:
Not In('80','90','86')

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

 

[fish2]

Still not working...The report is still showing the classes. What could I be doing wrong? HELP HELP! PLEASE

 

[fish2]

I figured it out....i needed to use the following expression:

<>" 90" And Not Like " 80" And Not Like " 86

 

[PHV]

Or this ?
Not In(' 80',' 90',' 86')

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