Null values (2003)

Topic

New Reply

How do you sort null values last in a query?

Reply | Quote

Replies

Add a calculated column:

NN: IsNull([FieldName])

and add the field itself (FieldName) to the right of this column, clearing the Show check box for both if you wish. Sort on both columns. Because True = -1 and False = 0, the null values will be sorted before the non-null values.

Reply | Quote

Thanks

Reply | Quote