Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    1

    Unanswered: Sorting question

    I have a table that sorts in chronolgical order by the description below:

    backup.Source = "SELECT * FROM backup ORDER BY start_date ASC"

    this works fine but I want to sort it the other way. Right now it sorts from a-z but how would I have it sort from z-a?

    Any help is greatly appreciated.


    -Bishop-

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    use DESC

    Hello,

    instead of ASC use DESC (for descending) ...

    Hope that helps ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •