How to query using 3 sets of data from 3 different fields ?

[KingOf206]

I am not sure if this is a simple or not, but hoping to find an answer.

I am trying to run a query and here is the information i want to pull all the records that have "OMR-A" in the field "sReturnChallengeAbbr". Then of those records, i only want to pull records that meet EITHER of the following 2 criteria, it WILL NOT equal the word "Mail" in the field "szAVStatusAbbr" or it WILL equal the number "1" in the field "iUOCAVARankEmail" .

Here is a pic of the current query (which does not work)





When i try and run this query it pulls WAAAY more records than it should and it doesnt following the roginal criteria rule of only pulling recrods that have "OMR-A" in the field "sReturnChallengeAbbr"

Any suggestions?

[pbaldy]

The OMR-A should be on both lines, the Mail and 1 should be on different lines. Same line = "AND", different line = "OR".

[KingOf206]

SO like this?

[pbaldy]

Yes; if it works.

[KingOf206]

Yes; if it works.

Does not work...

[pbaldy]

Can you attach the db here?

[KingOf206]

Ill do 1 better, after quite a few rounds of testing.. this is the qry design criteria that made it work..





this qry will search for records that do have OMR-A and will have either Not Mail OR 1 in their respective fields...

[pbaldy]

That works and the other didn't? This should return the same result. "In" is typically used when there's a list: In("abc", "def"). In this case, with only one item it should be the same as just entering the item as you did before.

[KingOf206]

That works and the other didn't? This should return the same result. "In" is typically used when there's a list: In("abc", "def"). In this case, with only one item it should be the same as just entering the item as you did before.

Correct, that worked and the other did not.

I had to write it in SQL (which im not good at) in order to figure out the design view..

[pbaldy]

I'd be curious to see the SQL of both. I'm missing something here. In any case, glad you got it sorted out.