RunCommand.SortAscending ignore Nulls?

[Bill Mitchell]

Hi,

When I use RunCommand.SortAscending it always lists Null
values FIRST. This is VERY BAD and if you think about
it, makes no sense (makes you wonder why they made it
that way - Why would anyone want to sort with empty
fields FIRST?).

Is there way to force RunCommand.SortAscending IGNORE
Null values or put them last instead of first?

Thanks.

 

[Allen Browne]

In the ORDER BY clause of a query or the OrderBy property of a form/report,
you can sort by the expression:
([MyField] Is Null) DESC, [MyField]
so that the null records fall to the bottom.