[thelist] Column Links for Sorting

[Daniel S. O'Shea]

I have an access database I want to create a hyperlink on each column
heading, so that when any column heading is clicked on, the query will
return the same table but sorted by the column clicked.

sql = "select qb.name, " -
             "qb.passatt, " _
             "qb.passyards, " -
             "qb.passint " -
      "FROM qb " _;"

If I just script- "Sort by qb.name " _;" then the table shows sorted by
player name.
How can I write a query so that hyperlinks exist on each column heading to
sort the table by a particular column??

Thanks