Read our new paper: Microsoft Access Sorting on Multiple Date (or Numeric) Fields with Blank Values
Learn how to sort on multiple date fields when null values exist by using a calculated field. By using the IIf function with Is Null, you can easily sort to see the most recent (or oldest) records.
We’ve included information on avoiding the IsNull function to maintain SQL Server compatibility. Additional information and examples are provided to show why using the NZ function (NullToZero) is not equivalent and returns the wrong results.
This new paper is part of our Microsoft Access Query Help Center.