"Not Equal And Not Equal" query not working

[pakorah]

I am trying to run a query where one field has a Not Equal parameter AND another field has Not Equal parameter (for example, Product Code Not Equal "A" AND Client State Not Equal "NY)

The result of the above query are all records that have Product Code = "A" are missing from the result. I want some of the "A" Product Codes; I just want to exclude the ones where the Client state is NY.

The list of values for each field is too big to state it in a positive way (I would have to list all the other 28 product codes and all the other 49 states).

What am I doing wrong? Thank you in advance for any suggestions.

 

[Vassago]

Are you sure you are using an AND parameter and not OR? The query in design view can be a bit misleading, try checking the actual sql code. It might help if you can post the sql exactly as you have it.