is null acending or descending?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

just modified a report and whereas previously it sorted nulls to the end of
the report (where i wanted them) & now it sorts null to the beginning ?

it's quite a complex report so i figure there is something undeath i haven't
noticed yet but:

by default should nulls acended or decended?
 
In Ascending, Nulls come first.
In Descending they come last.

In reorts, all the sorting is done through the Sorting & Grouping Dialog box, so check
that for what fields you have and how they are sorted.
 
You can change the way nulls sort by adding a calculated field to your
query. Type something like this into the Field Row:
ItsNull: ([MyField] Is Null)

You can then sort Ascending or Descending on this yes/no value to determine
whether the nulls are first or last, since yes sorts before No (in
Ascending).
 
Back
Top