Sorting

[sdpsc]

In a database, there is a field of numbers, which I want to sort by. However, if I have the numbers 1 through 10, it orders it like '1, 10, 2, 3", like its ordering by the first digit. How do I make it order by the actual number?

 

[sharedworld]

You have to make this field a number field in access, and not a text field. Then it will work.

 

[Tarwn]

One option would be to cast it toa numeric type in your query. Without knowing your exact database I couldn't tell you the functions to use, but basically you would want something similar to:

sql_string = "SELECT * FROM MyTable ORDER BY cInt(myNumberField)"

The only problem with this method isa that since those are text fiels you my have some non-numeric entries (like blanks) that will cause the attempt to cast to give you a nasty error.

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/