Need Advanced Filter with NOT equal string and OR criteria
Okay, I'll try to lay this out. The problem now is, using the Completed
criteria you gave me (and that _is_ how I indicated if they're completed), I
don't get lines returned that have NOTHING in the STATUS column.
Here's my timeline (I left off the row/column letters/numbers):
Event Milestone? Start End Status 11/28/05
12/5/05 12/12/05
Item 1 12/5 12/9 Completed
XXXXX
Item 2 12/5 12/16 In Process
XXXXX XXXXX
Item 3 12/5 1/13
XXXXX XXXXX
Item 4 Yes 3/31 4/5
(Item 4 would have x's way out in the columns for those future dates.)
My criteria could be JUST
Status
="<Completed"
Status
And all that would be returned would be the IN PROCESS item (#2).
What I REALLY want is criteria like
Milestone? 12/5 Status
Yes ="<Completed"
* ="<Completed"
to indicate that I want to see anything that's (NOT completed) AND (that is
supposed to occur any time during the week of 12/5 OR that is a milestone
(occurring any time).)
When I run that last query, though, I still DO NOT SEE BLANK STATUS items.
I really don't want to have to change all my blanks to NOT STARTED, but that
_does_ work. Why isn't it returning NULL values?
Thanks - hope this is readable!
|