Are you sure your logic is right?

What about a sales of 4500 which meets the OR <6500 condition as do sales of
10?



"ampozdol" wrote:

Hello,

Is there anyway to change the way that the Database function analyzes the
Criteria range?

Default is (according to
http://office.microsoft.com/en-us/as...spx#Example3):

Sales=A1 Sales=B1
6000=A2 <500=B2
<6500=A3
( (Sales 6000 AND Sales < 6500 ) OR (Sales < 500) )

I'm trying to get it to look at:

Sales=A1 Sales=B1
6000=A2 <500=B2
<6500=A3
( (Sales 6000 OR Sales < 6500 ) AND (Sales < 500) )

Thank you,

Aaron