Sort database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • blakedut2
    New Member
    • Aug 2008
    • 3

    Sort database

    Hello, now i have a database with two columns, time and name. I need the time and the name to stay with each other, but get resorted in the numbers ascending order. For example:

    Time: Name:
    12.65 Fred Button
    13.23 Adrian Middleton
    10.45 Alan Deathly
    4.3 Joe Breaker

    Now, the numbers have to stay with the names, but have to be sorted so the end result would be this:

    Time: Name:
    4.3 Joe Breaker
    10.45 Alan Deathly
    12.65 Fred Button
    13.23 Adrian Middleton

    Any help appreciated!
    Last edited by blakedut2; Aug 19 '08, 08:42 PM. Reason: typo
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    sort the time field and then concatinate with the other field and display.

    Comment

    Working...