 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006Database Function Criteria Boolean Operations
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 Are you sure your logic is right? What about a sales of 4500 which meets the OR <6500 condition as do sales of 10? > Hello, > [quoted text clipped - 19 lines] > > Aaron 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 > Are you sure your logic is right? > [quoted text clipped - 24 lines] > > > > Aaron 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. > Toppers, > [quoted text clipped - 34 lines] > > > > > > Aaron 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 > 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? [quoted text clipped - 40 lines] > > > > > > > > Aaron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.