MSAccess: Date Sort, Nulls to Bottom?
Posted on 2009-05-06
I've place a collection of radio buttons on a form to permit various sorting options. One of them is to sort on a date field. I have attempted to sort ascendingm with NULLS at teh bottom using the following approach:
Forms!MainForm![QAReport subform].Form.OrderBy = "nz([Due to Client],'ZZZ') ASC"
This does move the NULLS to the bottom, but the dates are not sorting correctly. Here is a sample - close but not quite:
Due From QA