Sort order

  • Thread starter Thread starter David
  • Start date Start date
D

David

This may seem quite trivial but it's actually quite
important and any help would be appreciated.

Sorting a field in ascending order always puts the
null/zero values before 1,2,3,4... Is there any easy way
of placing the null values at the end of the sorted list?

Thanks in advance.
 
Go to Sorting and Grouping (on the view menu I think) and rather than
entering your field name enter the expression

=IIf(isNull(NumField) or NumField=0,9999999,NumField)

where NumField is the name of your field and 9999999 is bigger than any
number in this field could ever be.

HTH
Sam
 
Back
Top