Why can't I use AND in SQL syntax when creating a new view?

N

N. P.

(I am using Office Outlook 2003.)



Hi all,

In my calender folders I want to apply a view which will:

Show all appointments arranged by Start date.

Show all future (active) appointments. But:

Do not show any future (active) appointment which is:

1. A holiday, 2. A birthday or 3. An Aniversary. ie. has one of these three
categories.

I hope that these desires of mine are not considered by Microsoft as too
extreme. After all, it is quite natural to want to see only your future
appointments except if they concern birthdays or holidays. Why shouldI be
force to view eg. holidays as well?

The issue is that this desire of mine cannot be realised. I tried the
following SQL statement in the Filter dialogbox of a new view I created:

("urn:schemas:calendar:dtstart" >= 'today' AND
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Aniversaries' AND
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Holidays' AND
"urn:schemas-microsoft-com:eek:ffice:eek:ffice#Keywords" <> 'Birthdays')

The AND between the Categories does not work! Why? Only the OR operator
works which is stupid since if you say not Birthdays or not Aniversaries
etc, everything will be included. Whilst you should be able to say not
Birthdays AND not Aniversaries, etc to get the desired results.

Please fix this!

Also in the Inbox I want to create a view showing all the e-mail which is up
to one week old and also all e-mails that have not been read. How can I do
that?

The Filter dialogbox does not allow you to say:

1. show e-mail that has been Read and which is in the last week,

and also,

2. show e-mail that is Unread.

Even Outlook Express can do that. Why not Office Outlook with its rich
viewing options?

Thanks,

N. P.
 

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