Can I Apply Two Filters to Task View?

  • Thread starter Thread starter mtbcpa
  • Start date Start date
M

mtbcpa

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?
 
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).
 
mtbcpa said:
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?
Click to expand...

See if this helps:
<http://groups.google.com/group/micr...read/thread/fb7fc1b1b0a01ef7/46292dddbdfa4336>
 
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).









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