Date sorting

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Hi all

I have an application where I display a list of records that I want so sort
ascending by a date field. The only problem is, that I have some entries in
the sorted field that ere empty, and they show up at the top of my list. Is
there any possibilitie to sort a field in ascending order and have empty
entries at the end??

Matt
 
Create a query with a calculated field, like this:
([MyDate] Is Null)
Choose Descending in the Sorting row under this field.
Place it left of the MyDate field.

The query now sorts all the records with where the date field is not null
first.
 
Back
Top