Custom Filtered View

C

ctc

I am trying to create a view of outlook contacts filtered to contain the
"Client" category, but not the "Xmas Residential" and not the "Xmas Business"
categories.

I have entered the following code into the SQL tab of the view's filter
utilizing the Advanced tab and defining the criteria as either "contains" or
"doesn't contain" and then on the SQL tab checking the "Edit these criteria
directly" box and changing "OR" to "AND" between each of the criteria:

("urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" LIKE '%Client%' AND
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Xmas Residential' AND
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Xmas Business')

The resulting view shows all contacts containing any one or more of the
categories which is not what I wanted.

Please advise.
 
M

Michael Bauer [MVP - Outlook]

That's how a filter on categories work, it must show a contact if it has at
least one of the categories assigned. You can turn off the group by
categories view in order to see any listed contact only once.

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 17 Dec 2009 07:38:02 -0800 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