Sort order

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

 

[Sam]

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