Sorting Query Results...

Results 1 to 2 of 2

Thread: Sorting Query Results...

  1. #1
    Dave Pifer Guest

    Default Sorting Query Results...

    After I&#039ve filtered a recordset and displaying the query results I would like to know how I could sort by column headers..for ex. column headers are Name - SSAN - City - State - Zip. I would like to click on one of column headers and then the query results would be sorted in descending order by the column header I clicked on. Thanks for any guidance you can assist me with.

  2. #2
    Join Date
    Dec 1969

    Default RE: Sorting Query Results...

    from what i know you will have to re-query to sort them i.e. you will have to re-query your table with the same filters and include an "order by" condition<BR><BR>use "order by fieldname desc" for descending, default is ascending.<BR><BR>

Posting Permissions

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