General discussion
July 3, 2003 at 11:30 PM
mozster

ACCESS’97 QUERY

by mozster . Updated 23 years, 2 months ago

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?

This discussion is locked

All Comments