Database Function Criteria Boolean Operations

[ampozdol]

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/assistance/HA012186941033.aspx#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

 

[Toppers]

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]

Toppers,

I'm not sure what you are asking. The logic operations are specified by
Microsoft at the link I included.

I'm also not sure where you are getting the numbers you quote, and how they
operate in a criteria range.

Aaron

 

[Toppers]

I don't understand your OR/AND logic: what exactly are you trying to include
in the filter ... Sales between 6000 & 6500 OR sales < 500?

Sales > 6000 OR < 6500 doesn't make sense to me whereas the >6000 AND < 6500
does.

 

[ampozdol]

Toppers,

I'm trying to include ( (Sales > 6000 OR Sales < 6500 ) AND (Sales < 500) )

So that it includes any of the A Column values AND any of the B Column
values. How the logic works now seems to be: include A1 AND B2, OR A2 AND
B2. I am looking for a way to say: include A1 OR B1, AND B1 OR B2. I am
trying to do this in order allow for my criteria table set up to
conditionally accept values based on user input.

Thank you,

Aaron