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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing null to "" in a form field. 3
managnig nulls in combobox sort 1
sorting: cleared/null v/s "" 3
Replace "assign the null value" message 1
Re-Insert Null value into database field 3
Exclude a field from WHERE clause, if null 3
List Box Paramater query with Null value 3
How can I force selection of the 1st record of multiselect listbox from VB 3

Back
Top