RunCommand.SortAscending ignore Nulls?

  • Thread starter Thread starter Bill Mitchell
  • Start date Start date
B

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.
 
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.
 
Back
Top