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-comfficeffice#Keywords" LIKE '%Client%' AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'Xmas Residential' AND
"urn:schemas-microsoft-comfficeffice#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.

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:

> 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-comfficeffice#Keywords" LIKE '%Client%' AND
> "urn:schemas-microsoft-comfficeffice#Keywords" <> 'Xmas Residential'
AND
> "urn:schemas-microsoft-comfficeffice#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.