Acending ordering

[habbabub]

when i perform a query and atribute a ascend ordering for a date feild, the blank feilds always show up on the top of the list, but the rest of the feilds are what i need. how can i keep the blank feilds at the bottom, whilst keeping the same ordering of the non blank feilds?

 

[khawar]

And why the fields are blank in the date column

 

[georgedwilkinson]

Instead of ordering by the field, order by nz(thefield,#12/31/9999#), or the highest date you can use. As I said, order by, don't display.

You can modify the order by clause quickly in SQL view.