Is there a 'Not in' function?

[PatrickM]

Is there a function that does the opposite of 'In'? i.e. something like:

number Not
In(220006981,220002440,220003485,220003092,220001646,220002547,220000157,220001183,220005633,220007178,220000415,210000167,220001600)

I could type out:
<>220006981 AND <>22000240, etc. but I've already got the above numbers
typed out in a different query in an 'In' criteria and would like to copy
them over to my new query for use in a 'Not In' criteria if it exists. In
any case, would be handy to know if such a function exists.

Thanks,
Patrick

 

[fredg]

Is there a function that does the opposite of 'In'? i.e. something like:

number Not
In(220006981,220002440,220003485,220003092,220001646,220002547,220000157,220001183,220005633,220007178,220000415,210000167,220001600)

I could type out:
<>220006981 AND <>22000240, etc. but I've already got the above numbers
typed out in a different query in an 'In' criteria and would like to copy
them over to my new query for use in a 'Not In' criteria if it exists. In
any case, would be handy to know if such a function exists.

Thanks,
Patrick

Didn't you at least try it?

Not In(220006981,220002440,220003485, etc...)

works for me if the field is a Number datatype.

If it is text datatype, then you need:

Not In("220006981","220002440","220003485", etc...)

 

[KARL DEWEY]

Didn't you at least try it?
Don't you just love those 'Will this work?'