is null acending or descending?

[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?

 

[Al Camp]

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.

 

[Allen Browne]

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).