Not Operator

[Guest]

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.

 

[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

 

[Lynn Trapp]

Tom,
You expect too much... <g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Tom Ellison]

Dear Lynn:

Yeah. I know it. Life is like that.

So, OK, you answer the question!

Tom

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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

 

[Lynn Trapp]

So, OK, you answer the question!

hmmmmmmmmm... I'd answer it the same you you did... LOL

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Tom Ellison]

Dear Rugiem:

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

Tom Ellison