Re: Sort Ascending

Tech-Archive recommends: Fix windows errors by optimizing your registry

I tried this and it worked. However, users will eventually be able to update
this field with the correct date. With this code users cannot update the
field. You cannot edit it.

Douglas J. Steele wrote:
Easiest solution would be to add a computed field to the query, and sort on
that computed field.

Assuming that the records with no date actually have a Null value stored for
the date, the computed field should be

Nz([MyDateField], #12/31/9999#)

I am trying to sort a list of dates on a continuous form. I want it
ascending. However, there are some entries that do not have any dates. I
[quoted text clipped - 3 lines]

Any ideas?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200610/1

.