Not Operator

R

Rugiem

How do I use the NOt operator in a query where I am trying to eleminate a
bunch of payors. I cant seem to get it to work.
 
T

Tom Ellison

Dear Rugiem:

Details please! Table layout, sample data, sample query, explanation of
which rows in the sample data you want to eliminate or which to remain.

Tom Ellison
 
T

Tom Ellison

Dear Lynn:

Yeah. I know it. Life is like that.

So, OK, you answer the question!

Tom
 
K

Klatuu

As Tom said, more info would be helpful, but one approach would be
NOT IN("payor1", "payor3", "payor5", "payor7")
Then it will return all rows where the value is not in the list.
 
R

Rugiem

I have a table that has a field (payor). I have over 50 different kinds of
payors. I want to be able to elimanate certain payors. I tried using the
"not" operator to elemanite some of these payors in the criteria( not
medicare or horizon, or etna etc). It does'nt work. what am I doing worong?
 
R

Rugiem

It did not work. It returnd all the records including those i am trying to
eleminate.
 
T

Tom Ellison

Dear Rugiem:

Perhaps then it would work if you did not put in the NOT.

Tom Ellison
 
Top