Is there a 'Not in' function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PatrickM - 23 Apr 2008 21:34 GMT

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

Reply to this Message

fredg - 23 Apr 2008 21:48 GMT

> Is there a function that does the opposite of 'In'? i.e. something like:
>
[quoted text clipped - 9 lines]
> 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...)

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

KARL DEWEY - 24 Apr 2008 00:19 GMT

>>Didn't you at least try it?

Don't you just love those 'Will this work?'

Signature

KARL DEWEY
Build a little - Test a little

> > Is there a function that does the opposite of 'In'? i.e. something like:
> >
[quoted text clipped - 19 lines]
>
> Not In("220006981","220002440","220003485", etc...)

Reply to this Message