sort query with null values at end

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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?
 
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?
Click to expand...

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
 
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.
 
Back
Top