A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"AND" searches instead of "OR"



 
 
Thread Tools Display Modes
  #1  
Old July 14th, 2004, 05:24 PM
Toni Carlson
external usenet poster
 
Posts: n/a
Default "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  
Old July 20th, 2004, 09:51 PM
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: n/a
Default "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  
Old July 21st, 2004, 12:35 AM
Toni Carlson
external usenet poster
 
Posts: n/a
Default "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  
Old February 5th, 2009, 06:25 PM posted to microsoft.public.outlook.general
brettnnyc
external usenet poster
 
Posts: 1
Default "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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.