Having trouble sorting this...

Results 1 to 2 of 2

Thread: Having trouble sorting this...

  1. #1
    Join Date
    Dec 1969

    Default Having trouble sorting this...

    I have a table with various fields andin one field (status) a status of either hight, medium or low is inserted. These are taken out of a joined table. However I want to sort the results from the first table on their status: high first then medium then low. How can I do this? Obviously the normal alphabetic way isn&#039;t much use! <BR><BR>Any ideas? Ta

  2. #2
    Join Date
    Dec 1969

    Default RE: Having trouble sorting this...

    simplest way is to add a new field called sortorder, this will be numeric and can containg the order you want<BR><BR>High - 1<BR>Medium - 2<BR>Low - 3<BR><BR>Then just sort ASC by this

Posting Permissions

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