Changing sort order in a subform

[Guest]

I have a subform in which, for each person, there are several records. The
last record will always be null in the field I have to sort by. When I sort
descending, Access puts the blank row first, which is out of chronological
order. Is there any way to sort descending and then add the blank row at the
end? That is the only thing I could think of, but can't figure out how.
Thanks in advance.
Tim

 

[John Vinson]

I have a subform in which, for each person, there are several records. The
last record will always be null in the field I have to sort by. When I sort
descending, Access puts the blank row first, which is out of chronological
order. Is there any way to sort descending and then add the blank row at the
end? That is the only thing I could think of, but can't figure out how.
Thanks in advance.
Tim

If it's a date field, add a calculated field:

SortDate: NZ([datefield], #12/31/9999#)

and sort by that, descending. You can't have a later date than that in
Access so it will of necessity appear first.

John W. Vinson[MVP]