Not Equal to

F

Foxtrot

Hi

I'm trying to exclude certain records when i run queries but the records
stay in the query - any specific reason for this?
 
F

Foxtrot

Thanks, i'm trying to exclude the following records "BOL - INHOUSE SALES"
with criteria and or - it seems that i use the wrong command - can you help
me with the right command, an example? t
 
O

Ofer Cohen

As a criteria for the field you can try
<> "BOL - INHOUSE SALES"

Or try
Not In ("BOL - INHOUSE SALES" )

If it doesn't work, chek if the text is right
 
F

Foxtrot

Thanks again, that is working but when i want to add more exclusions, it is
not working, <> "BOL - INHOUSE SALES" or "TESTING" it will only exclude the
one.

I need to exclude multiple names?

How?
Thanks
 
O

Ofer Cohen

For that use the second example

Not In ("BOL - INHOUSE SALES" , "Second filter" , "Third filter" , "etc")
 
L

Larry Linson

Foxtrot said:
Thanks again, that is working but when i want to add more exclusions, it
is
not working, <> "BOL - INHOUSE SALES" or "TESTING" it will only exclude
the
one.
Click to expand...

That would be <> "BOL - INHOUSE SALES" AND <> "TESTING". You want to excude
both... If you try it with <> "BOL - INHOUSE SALES" OR <> "TESTING", you'll
see that you retrieve both.

But, I am puzzled... Ofer asked you to post the SQL, but instead you chose
to post a description. What you have, and what you are doing may be obvious
to you as you have the database in front of you; what you describe may not
be obvious to us -- that is why we ask for specifics to be copied and
pasted.

I am wondering just what part of "post the SQL" was not clear?

Larry Linson
Microsoft Access MVP
 
Top