In Access’97 I want to sort a date field inside a form so any empty (null) values appear first and then in order of the most recent dates after that.
At the moment its sorted in DESC order which gives me the most recent dates first but all the NULL fields go to the end.
Is there any way of doing this in Access?