Re: Sort Ascending

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#)


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"ladybug via AccessMonster.com" <u21071@uwe> wrote in message
news:67f37481c26d0@xxxxxx
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
want these entries to be at the bottom.
Currently, these entries without dates are at the top because of the
ascending sort.

Any ideas?

--
Message posted via http://www.accessmonster.com



.

Relevant Pages

  • Re: Sort file by computed field
    ... You say that you are to sort on a computed field that is not in the ... would appear as the first record of the output file along with all the ... something like all between one value and the next group minus one. ...
    (comp.lang.cobol)
  • Re: Sort file by computed field
    ... >How do I sort records in a file based on a computed field based on two ... You use the SORT verb. ... The OUTPUT PROCEDURE prints the report. ...
    (comp.lang.cobol)
  • Re: Sorting Months
    ... Add a computed field that returns the month number (either the Month ... function, or format as mm, not m). ... Sort on that field, even if you don't ... > instead of by calendar order. ...
    (microsoft.public.access.reports)
  • Re: Sort file by computed field
    ... > How do I sort records in a file based on a computed field based on two ... Seeing that this is a COBOL newsgroup - how about using a COBOL sort? ...
    (comp.lang.cobol)
  • Re: Sort by Month
    ... Add a computed field to your query, and sort by it. ... > format of dd/mm/yy. ...
    (microsoft.public.access.queries)