sorting fields with blank entries

[Guest]

Is there a way to make fields with blank entries appear at the bottom of a
sort instead of the top? I'd like to sort tasks by Due Date, and have tasks
without a Due Date appear at the bottom.

 

[Milly Staples [MVP - Outlook]]

If you click on that column heading, does it re-sort?

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.


After furious head-scratching, Sheryl asked this group:

| Is there a way to make fields with blank entries appear at the bottom
| of a sort instead of the top? I'd like to sort tasks by Due Date, and
| have tasks without a Due Date appear at the bottom.

 

[Guest]

Of course if I reverse the sort order the empty fields are on the bottom, but
then so are my highest priority tasks.

I want to sort tasks in ascending order by Due Date so that the earliest
deadline (most urgent task) is at the top of the list. But since NULL is
before any character in the natural sort order, when I do this I get my least
urgent tasks (the ones without Due Dates) on top, and the ones I want to see
after this. If I reverse the order, then I get the tasks with due dates
farthest in the future at the top of the list, which is not what I want
either.

As it stands now, the tasks I want to be on top end up buried in the middle
of the list, no matter which way I sort.

Ideally, Outlook would have more options for how to treat empty fields than
to just not show them, since I want to see the tasks without Due Dates. I
just don't want them first in the list.

Since Outlook apparently doesn't have this option (or at least not that I
can find), I'd secondarily be interested in ideas for how to handle it with a
script.