Modify Custom View SQL Filter Tab

C

ctc

I am trying to create a custom view which filters my Outlook 2007 contacts by
specific categories.

I would like my custom view to show all contacts which include a category of
Attorney, but exclude all contacts which include the categories of MIA, or
KIA, or Client, or Craig's Friends, or Craig's Relatives.

To do this I have used the Advanced tab to enter the above criteria into the
views filter:

("urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" LIKE '%Attorney%' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'MIA' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'KIA' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Client' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Craig''s Friends' OR
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Craig''s Relatives')

This filter returns all contacts which do not include Attorney as a
category, which does not produce the desired results.

How can I use the SQL tab to customize my filter to obtain the desired
results?
 
M

Michael Bauer [MVP - Outlook]

Use the AND operator instead of OR. However, if one contact is assigned to
both 'Attorney' and 'MIA', the filter will return it.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
<http://www.vboffice.net/product.html?lang=en>


Am Fri, 2 Apr 2010 09:49:02 -0700 schrieb ctc:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top