Need Advanced Filter with NOT equal string and OR criteria
I really can't see how your layout is but ="<Completed"
will return everything that does not have "Completed" both "In Process" and
blanks in the Status column so presumably the problem lies in your criteria
when using the dates and milestones
1. I notice that you are using 12/5, do you realise that if you just type in
m/d it will always default to current year?
If you want to start with 12/05/05 as a starting date and milestone yes and
not completed you need something like this for the criteria
Milestone Start Status
Yes ="=12/05/05" <Completed
--
Regards,
Peo Sjoblom
"MK" wrote in message
...
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!
|