If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"AND" searches instead of "OR"
How can I get Outlook 2003 (and BCM) to perform "AND" searches? For instance if I want to find contacts who are flagged as Category A AND Category B. If you do an advanced find and choose both categories, it finds everyone who is A OR B but I want only the people who are both. Going to the "Advanced" tab lets you get specific on search criteria but does not let you insert the "AND" to control how multiple criteria get applied. This seems so simple and so necessary!
|
#2
|
|||
|
|||
"AND" searches instead of "OR"
You'll laugh: Just type in A AND B in the Categories box on the More Choices
tab in Advanced Find. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Toni Carlson" Toni wrote in message ... How can I get Outlook 2003 (and BCM) to perform "AND" searches? For instance if I want to find contacts who are flagged as Category A AND Category B. If you do an advanced find and choose both categories, it finds everyone who is A OR B but I want only the people who are both. Going to the "Advanced" tab lets you get specific on search criteria but does not let you insert the "AND" to control how multiple criteria get applied. This seems so simple and so necessary! |
#3
|
|||
|
|||
"AND" searches instead of "OR"
I have never felt more stupid! Thank you!
"Sue Mosher [MVP-Outlook]" wrote: You'll laugh: Just type in A AND B in the Categories box on the More Choices tab in Advanced Find. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Toni Carlson" Toni wrote in message ... How can I get Outlook 2003 (and BCM) to perform "AND" searches? For instance if I want to find contacts who are flagged as Category A AND Category B. If you do an advanced find and choose both categories, it finds everyone who is A OR B but I want only the people who are both. Going to the "Advanced" tab lets you get specific on search criteria but does not let you insert the "AND" to control how multiple criteria get applied. This seems so simple and so necessary! |
#4
|
|||
|
|||
"AND" searches instead of "OR"
Sue,
Can you break this down for me please? I am trying to do the same thing but I'm not sure where you're putting A and B. I want to search for a contact with ONLY this category combination: "New York" and "Admin" and "Excel" ... I run a staffing company and I've categorized candidates with specific categories based upon their skills/location/title and I'm trying to pull only those candidates with the categories entered. I keep getting everyone from New York in my searches whether they are Admin and Excel or not. Thank you, Brett Sloan "Sue Mosher [MVP-Outlook]" wrote: You'll laugh: Just type in A AND B in the Categories box on the More Choices tab in Advanced Find. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Toni Carlson" Toni wrote in message ... How can I get Outlook 2003 (and BCM) to perform "AND" searches? For instance if I want to find contacts who are flagged as Category A AND Category B. If you do an advanced find and choose both categories, it finds everyone who is A OR B but I want only the people who are both. Going to the "Advanced" tab lets you get specific on search criteria but does not let you insert the "AND" to control how multiple criteria get applied. This seems so simple and so necessary! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
wildcard searches in bound list box possible? | EdwardA | Using Forms | 0 | June 10th, 2004 07:17 PM |
If statements with wild card searches | tony O | Worksheet Functions | 1 | September 19th, 2003 02:44 AM |