Hi all,
I am trying to sort dates in access. I know, the question is posted everywhere (I know because I've looked for the answer), except that not a single answer has proven right.
In a continuous form, I am trying to sort a date field (Date/Time (Short Date)). The following code is On Click event.
Forms("MyForm").OrderBy = "Nz([MyField],'a')"
Forms("MyForm").OrderByOn = True
This works to keep the dates at the top and the blanks to the bottom, however, the dates are displayed like so
18/01/2016
17/01/2016
24/12/2015
27/12/2015
31/12/2015
5/02/2016
6/01/2016
8/01/2016
This is completely bizzare and I don't understand why it's not working.
It is supposed to look like:
24/12/2015
27/12/2015
31/12/2015
8/01/2016
6/01/2016
18/01/2016
17/01/2016
5/02/2016
Can anybody please advise why this is not working and how to make it do what I need it to do.
Cheers
Bookmarks