Mar 20

Microsoft Access Query Sorting on Multiple Date or Numeric Fields with Blank Values

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.

Microsoft Access QueriesThis new paper is part of our Microsoft Access Query Help Center.