Diificult for me to explain, and the sysop here has put a limit on images so I try to do it with 1 image: (Sorry about the "zoom" I don't know what's that all about, but it's still clear.. thanks for your time Please just change the thumb to full size.. thanks)
This is my desired result:
However, to get to that result does not make sense to me considering the criteria's OR operator.. Let me try to explain..
Why does my criteria have to be on the same row?
a} here is the original search: http://img401.imageshack.us/img401/2004/q1wx4.jpg
To get this result:
http://img294.imageshack.us/img294/5839/q2uv9.jpg
Now, when I add this "S4S" like this:
http://img294.imageshack.us/img294/672/q3ml7.jpg
the query bombs out and gives me this:
http://img413.imageshack.us/img413/8008/q4an4.jpg
So to get my query correct to show only "S4S" I have to change the desgn to this:
http://img413.imageshack.us/img413/7937/q5tp7.jpg
So I can get my desired result of this:
http://img413.imageshack.us/img413/5755/q6gt6.jpg
Why is that?
thanks
The answer is very simple. Criteria in different rows are evaluated from left to right (first row), then down to next row. Criteria in the same row, different columns are evaluated as "And" criteria. Criteria in the same column, but different rows are evaluated as "Or" criteria. Therefore when you had the criteria set as follows:
standard..............S4S
utility
it is evaluated as follows:
(standard and S4S) Or Utility
in order to get it to evaluate the way you want it, you can do it either of two ways:
1.the first way is to put all your criteria in a single row like you did. Evaluating the criteria from left to right:(standard Or utility) And S4S .
2.the second way is to put your criteria in two rows as shown:
standard ..................S4S
utility........................S4S
which is evaluated from left to right and then down as follows:
(standard and S4S) Or (utility and S4S)
5
