Sorting Value Lists in Descending Order with "NULL" in the equation.

[Jarvis]

I have a task management program for my cabinetshop.

Tasks are assigned priority 1-2-3 from a valuelist.

There may be 10 items on the list but only three are in play at any time.

The focus for 1-2-3 essentially means:

Do this one now.

Do this one next.

Do this one if you something hangs you up on priority 1 or 2.

By constraining the priorities to 1-2-3 we minimize the things under consideration.

THE PROBLEM IS: when we perform a descending sort on this value list all of the tasks that have no priority assignments show up at the top of the list.

I would like the sort to be essentially equal to:

1

2

3

""

Is there anyway to keep the tasks that have not been assigned a priority at the bottom of the list?

[comment]

See:

http://fmforums.com/forum/topic/79152-custom-sort-question/

[Jarvis]

Thanks Comment.

That link provided a good idea.

I did a work-around that set the value to 999 upon record creation.

This automatically put the "empty" fields at the bottom of the list.

I then conditionally colored the font to disappear on the layout so that it would not be so distracting.

Would be nice to have an option to dis-include these values in the list if null.

[comment]

It's too bad you didn't read to the end of that thread.