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.

Microsoft Access QueriesWe’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.

Leave a Reply

Your email address will not be published. Required fields are marked *