Bebopgeo Posted August 30, 2007 Share Posted August 30, 2007 I have a database with a column with numbers in it, and I have a dynamic table that will display these numbers and I want to display these numbers by the number that I put in for the query say 6 and the list will list all the numbers starting with 6 in the top row and go down the list with 5 or 7 then 4 or 8 then 3 or 9 and so no. I want the numbers to be displayed with one number higher and one number lower then the number that I put in for the query in a high and low or a low and high from the entered number. Like Row1 = 6 is entered valueRow2 = 5Row3 = 7Row4 = 4Row5 = 8Row6 = 3Row7 = 9 Link to comment Share on other sites More sharing options...
justsomeguy Posted August 30, 2007 Share Posted August 30, 2007 You will have to get all the rows in numerical order and then sort them yourself, there's nothing you can do in SQL to get the rows in some arbitrary order like that. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.