Changing sort order in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top