 |
 | 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 / Outlook / Contacts / March 2005Understanding fliters in Contact views
Using OL 2002 SP3; I have multiple categories for my contacts. Some contact are in 3 or more categories. Trying to create a contact view for only current business contacts. I have created the view "temp"; applied filters to the view under 'Customize current view' as: Categories - doesen't contain - Past Categories - doesen't contain - Jacks Personal the SQL tab shows 'OR' being applied [but I am not editing criteria directly] however contacts with categories 'OFS, Lithchem, Jacks Personal' show up in the view as well as contacts with only 'Jacks Personal' I have checked spelling and capitaization - why is this happening?  SignatureJack S Think about your logic: 'OFS, Lithchem, Jacks Personal' meets one of your two criteria (Categories - doesen't contain - Past) and therefore an item with that value will appear. Perhaps you want And not Or? SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Using OL 2002 SP3; I have multiple categories for my contacts. Some contact > are in 3 or more categories. Trying to create a contact view for only current [quoted text clipped - 6 lines] > the view as well as contacts with only 'Jacks Personal' > I have checked spelling and capitaization - why is this happening? using the SQL tab, I changed OR to AND between the two criteria - now the "Jacks Personal"-only contact is eliminated from the view but I now see [more investigation] that with either OR or AND there are also some 'Past" contacts listed. There is even one contact with only 'Past' and Jacks Personal' categories - and it is listed! I want to filter out any contact that contains either the 'Past' category or one that contains 'Jacks Personal'. Each is to be filtered out. Am I going crazy? > Think about your logic: 'OFS, Lithchem, Jacks Personal' meets one of your two criteria (Categories - doesen't contain - Past) and therefore an item with that value will appear. > [quoted text clipped - 10 lines] > > the view as well as contacts with only 'Jacks Personal' > > I have checked spelling and capitaization - why is this happening? Because you can have multiple values for and item in the category field, the filter/SQL logic for categories is different than for fields that have only one value at a time. Also, make sure that all category values are in the Master Category List and that the Category values in your filters correspond exactly and only to those values. Applying "NOT" and "OR" to the same filter can make for a pretty weak filter. does this mean I cannot do what I want - filter out all 'Past' and all 'Jacks Personal' catagories from being displayed? Can you explain more fully how "the filter/SQL logic for categories is different than for fields"? bottom line - can any one explain how to accomplish my task? or tell me it is not possible - and if not why not? > Because you can have multiple values for and item in the category > field, the filter/SQL logic for categories is different than for fields [quoted text clipped - 6 lines] > Applying "NOT" and "OR" to the same filter can make for a pretty weak > filter. |
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.