If you need to get a report sorted and grouped by date but your query contains null values use this expression to solve your dilemma.
=IIf([Ship Date] Is Null,1,0) |
Within your Group, Sort, and Total Window set the Sort by to expression:
Add in our code. Ok to finish and your nulls are now at the end of the list.
