Hi all. This is question is obstensibly about Access, but deals with SQL
syntax, which is why I am cross-posting.
I've got a table called 'MyTable' with a date field called 'MyDate'. I want
to select the values from that field and display them in ascending order.
"SELECT MyDate FROM MyTable ORDER BY MyDate ASC"
However, it always puts the empty (Null) fields up top when it returns the
results. Is there any way I can convert the MyDate type in SQL so that the
Null fields appear at the bottom of the list?
Any help would be appreciated. Thanks!