sort query with null values at end

[Jennifer]

I want my query to place all of the null values in the sort field at the end.
But only have ascending or descending as option. Is it possible?

 

[fredg]

I want my query to place all of the null values in the sort field at the end.
But only have ascending or descending as option. Is it possible?

Add a new column to your query:
SortMe:IIf(IsNull([SortFieldName]),2,1)
Sort this column Ascending
Move this column to the left of the [SortFieldName] column.
You can uncheck the column's Show check box

Sort [SortFieldName] Ascending

 

[KARL DEWEY]

Add a calculated field just for sorting like this --
MySort: IIF([YourField] Is Null, "Z", " ") & [YourField])
This will place a leading space if it is not null and a 'Z' if it is.