Filter a calendar view

[Shane Nation]

Hi

I am using Outlook 2003 and I am trying to filter a view of my calendar.
I have appointments which have all have categories assigned to them and I
want to view all appointments that DON'T have category "a" or category "b"
assigned to them. Some appointments will have both "a£ and "b" assigned to
them.

I have one into view - arrange by - current view -define views (Chosen the
view I want) - modify - filter - advance tab and entered two rules
"Categories doesn't contain a" and "Categories doesn't contain b".

This hides all the ones containing "a" and the ones containing "a" and "b"
but not the ones containing "b" on it's own.

I have also trie the rule "Categories doesn't contain a, b" but that doesn't
work either.

Please can any one help?

Thanks

Shane

 

[Guest]

Next to the Advanced tab in the Filter dialog, there should be a SQL tab. If
you click that tab and look at the SQL data you will see that the rule has
been set up as an OR rule. Check the box that says "Edit these values
directly" and change the OR in the rule to AND. See if that works.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***

 

[Shane Nation]

Thanks for the advice.
I now have this statement in the SQL section

("urn:schemas-microsoft-comfficeffice#Keywords" <> 'Work' AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'NPfIT')

Which works fine if I have one or the other as a category, however if I have
both "Work" & "NPfIT" as categories it fails?

Thanks

Shane
"Jocelyn Fiorello [MVP - Outlook]"

 

[Guest]

OK, I got some help from my fellow Outlook MVPs on this one (who are much
more SQL-savvy than I) -- try this statement instead:

(NOT("urn:schemas-microsoft-comfficeffice#Keywords" LIKE 'Work') AND NOT
("urn:schemas-microsoft-comfficeffice#Keywords"
LIKE 'NPfIT'))

Does that one do what you want?

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***

Thanks for the advice.
I now have this statement in the SQL section

("urn:schemas-microsoft-comfficeffice#Keywords" <> 'Work' AND
"urn:schemas-microsoft-comfficeffice#Keywords" <> 'NPfIT')

Which works fine if I have one or the other as a category, however if I have
both "Work" & "NPfIT" as categories it fails?

Thanks

Shane
"Jocelyn Fiorello [MVP - Outlook]"

Next to the Advanced tab in the Filter dialog, there should be a SQL tab.
If
you click that tab and look at the SQL data you will see that the rule has
been set up as an OR rule. Check the box that says "Edit these values
directly" and change the OR in the rule to AND. See if that works.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply
only to the newsgroup to preserve the message thread. ***