A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Can I Apply Two Filters to Task View?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 20th 08, 05:41 PM posted to microsoft.public.outlook
mtbcpa
external usenet poster
 
Posts: 55
Default Can I Apply Two Filters to Task View?

It seems to me that when I add a filter to a task view for something
like category "does not contain" xyz, and then add right below that,
category "does not contain" abc, it should show all of my tasks, but
just not anyone that has xyz OR abc in the category. But, if I add
the first filter, it seems to work ok, but when I add the second, it
just makes all of the filtering not work. Am I missing something?
Ads
  #2  
Old June 20th 08, 10:12 PM posted to microsoft.public.outlook
Diane Poremsky {MVP}
external usenet poster
 
Posts: 1,260
Default Can I Apply Two Filters to Task View?

when you use two of the same criteria they are OR'd together. Try using abc
AND xyz as the condition (it works with some fields but may not work with
all) or use the QueryBuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:


** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **




"mtbcpa" wrote in message
...
It seems to me that when I add a filter to a task view for something
like category "does not contain" xyz, and then add right below that,
category "does not contain" abc, it should show all of my tasks, but
just not anyone that has xyz OR abc in the category. But, if I add
the first filter, it seems to work ok, but when I add the second, it
just makes all of the filtering not work. Am I missing something?


  #3  
Old June 20th 08, 10:44 PM posted to microsoft.public.outlook
Diane Poremsky {MVP}
external usenet poster
 
Posts: 1,260
Default Can I Apply Two Filters to Task View?

oops - if you AND them it won't work unless an item uses both categories .
You could try abc OR xyz on one like or just use querybuilder.

Working with double negative queries can really be confusing. OR fails
because when it checks the first criteria, it finds all that do not contain
abc as expected... then when it looks for those that don't contain xyz, it
finds abc because it doesn't contain xyz.

Outlook is reading the two lines like this:
(doesn't contain abc) or (doesn't contain xyz)
but you need:
doesn't contain (abc or xyz).




"Diane Poremsky {MVP}" wrote in message
...
when you use two of the same criteria they are OR'd together. Try using
abc AND xyz as the condition (it works with some fields but may not work
with all) or use the QueryBuilder:
http://www.outlook-tips.net/archives/2004/20040927.htm

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:


** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **




"mtbcpa" wrote in message
...
It seems to me that when I add a filter to a task view for something
like category "does not contain" xyz, and then add right below that,
category "does not contain" abc, it should show all of my tasks, but
just not anyone that has xyz OR abc in the category. But, if I add
the first filter, it seems to work ok, but when I add the second, it
just makes all of the filtering not work. Am I missing something?


  #4  
Old June 23rd 08, 02:09 PM posted to microsoft.public.outlook
Brian Tillman
external usenet poster
 
Posts: 17,452
Default Can I Apply Two Filters to Task View?

mtbcpa wrote:

It seems to me that when I add a filter to a task view for something
like category "does not contain" xyz, and then add right below that,
category "does not contain" abc, it should show all of my tasks, but
just not anyone that has xyz OR abc in the category. But, if I add
the first filter, it seems to work ok, but when I add the second, it
just makes all of the filtering not work. Am I missing something?


See if this helps:
http://groups.google.com/group/microsoft.public.outlook/browse_thread/thread/fb7fc1b1b0a01ef7/46292dddbdfa4336
--
Brian Tillman [MVP-Outlook]

  #5  
Old June 23rd 08, 04:14 PM posted to microsoft.public.outlook
Diane Poremsky {MVP}
external usenet poster
 
Posts: 1,260
Default Can I Apply Two Filters to Task View?

1. you can't run rules on tasks.
2. the tasks already have a category. They need a filter that allows a
double negative. QueryBuilder will allow this. They can also use the SQL
tab to edit the query, although that method seems a bit buggy in Outlook
2007 (queries that Outlook created fail if you copy and paste them).

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:


** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **




"Brian Tillman" wrote in message
...
mtbcpa wrote:

It seems to me that when I add a filter to a task view for something
like category "does not contain" xyz, and then add right below that,
category "does not contain" abc, it should show all of my tasks, but
just not anyone that has xyz OR abc in the category. But, if I add
the first filter, it seems to work ok, but when I add the second, it
just makes all of the filtering not work. Am I missing something?


See if this helps:
http://groups.google.com/group/microsoft.public.outlook/browse_thread/thread/fb7fc1b1b0a01ef7/46292dddbdfa4336
--
Brian Tillman [MVP-Outlook]


  #6  
Old June 23rd 08, 06:48 PM posted to microsoft.public.outlook
Brian Tillman
external usenet poster
 
Posts: 17,452
Default Can I Apply Two Filters to Task View?

Diane Poremsky {MVP} wrote:

1. you can't run rules on tasks.


D'oh! I missed some important things in the original message, didn't I?
--
Brian Tillman [MVP-Outlook]
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
View Filters Problem mtbcpa Outlook - General Queries 1 June 16th 08 07:01 PM
Outlook 2k3: How to apply a personal Form to an existing task news.microsoft.com Outlook and VBA 3 November 23rd 06 05:37 PM
Task filters should be linked to calendar filters fetch98 Outlook - Calandaring 0 January 19th 06 09:06 PM
Customise View Filters deandepetra Outlook - Using Contacts 0 January 17th 06 03:16 AM
Apply weekly view to daily view Rhys Davies Outlook - Calandaring 1 January 12th 06 10:45 AM


All times are GMT +1. The time now is 12:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.