Not Equal to

[Guest]

Hi

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

 

[Guest]

Can you post the SQL?

And an example for the filter you are trying to do.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

For that use the second example

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

 

[Larry Linson]

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.

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