Customise current view

I have a number of categories set up on my outlook.
However i don't want the appointments in 3 of these
categories to be visible at certain times. The ones i do
want visible are those with the default null value in the
categories field.

i created a filter under view, current view, customise
current view, filter, more choices tab, and inserted 1
category that i didn't want visible. i then went into the
SQL tab and changed the syntax from ='personal' to
'personal' - this worked by displaying everything in my
outlook except for appointments with personal as the
category. However, when i then tried to add another
category i wanted omitting it went back to displaying
everything.

Can anyone help?

What is the syntax you used in the SQL tab for adding another category?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"JM" wrote in message
...
I have a number of categories set up on my outlook.
However i don't want the appointments in 3 of these
categories to be visible at certain times. The ones i do
want visible are those with the default null value in the
categories field.

i created a filter under view, current view, customise
current view, filter, more choices tab, and inserted 1
category that i didn't want visible. i then went into the
SQL tab and changed the syntax from ='personal' to
'personal' - this worked by displaying everything in my
outlook except for appointments with personal as the
category. However, when i then tried to add another
category i wanted omitting it went back to displaying
everything.

Can anyone help?

I entered :

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
("urn:schemas-microsoft-comfficeffice#Keywords"
'Personal')

which works for 1 catergory, however for more than 1 I
entered:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("urn:schemas-microsoft-comfficeffice#Keywords"
'Personal' OR "urn:schemas-microsoft-
comfficeffice#Keywords" 'Birthdays'))

which is where it didn't work.

-----Original Message-----
What is the syntax you used in the SQL tab for adding
another category?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"JM" wrote in
message
...
I have a number of categories set up on my outlook.
However i don't want the appointments in 3 of these
categories to be visible at certain times. The ones i
do
want visible are those with the default null value in
the
categories field.

i created a filter under view, current view, customise
current view, filter, more choices tab, and inserted 1
category that i didn't want visible. i then went into
the
SQL tab and changed the syntax from ='personal' to
'personal' - this worked by displaying everything in
my
outlook except for appointments with personal as the
category. However, when i then tried to add another
category i wanted omitting it went back to displaying
everything.

Can anyone help?


.

Try changing that last OR to AND.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


wrote in message
...
I entered :

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
("urn:schemas-microsoft-comfficeffice#Keywords"
'Personal')

which works for 1 catergory, however for more than 1 I
entered:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("urn:schemas-microsoft-comfficeffice#Keywords"
'Personal' OR "urn:schemas-microsoft-
comfficeffice#Keywords" 'Birthdays'))

which is where it didn't work.


"JM" wrote in
message
...
I have a number of categories set up on my outlook.
However i don't want the appointments in 3 of these
categories to be visible at certain times. The ones i
do
want visible are those with the default null value in
the
categories field.

i created a filter under view, current view, customise
current view, filter, more choices tab, and inserted 1
category that i didn't want visible. i then went into
the
SQL tab and changed the syntax from ='personal' to
'personal' - this worked by displaying everything in
my
outlook except for appointments with personal as the
category. However, when i then tried to add another
category i wanted omitting it went back to displaying
everything.

Can anyone help?


.

Thanks for that i think its worked, HOWEVER, i now can't
see all my business entries which have a default category
of NULL, i am sure this was working until today !!

JM
-----Original Message-----
Try changing that last OR to AND.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


wrote in message
...
I entered :

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
("urn:schemas-microsoft-comfficeffice#Keywords"
'Personal')

which works for 1 catergory, however for more than 1 I
entered:

("DAV:isfolder" = false AND "DAV:ishidden" = false) AND
(("urn:schemas-microsoft-comfficeffice#Keywords"
'Personal' OR "urn:schemas-microsoft-
comfficeffice#Keywords" 'Birthdays'))

which is where it didn't work.


"JM" wrote in
message
...
I have a number of categories set up on my outlook.
However i don't want the appointments in 3 of these
categories to be visible at certain times. The ones
i
do
want visible are those with the default null value
in
the
categories field.

i created a filter under view, current view,
customise
current view, filter, more choices tab, and
inserted 1
category that i didn't want visible. i then went
into
the
SQL tab and changed the syntax from ='personal' to
'personal' - this worked by displaying everything
in
my
outlook except for appointments with personal as the
category. However, when i then tried to add another
category i wanted omitting it went back to
displaying
everything.

Can anyone help?


.



.