Sorting Database records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access Database feeding asp on the web. The "sorted data" (for
example) follows the following sort order of the records 1,11,111, then
,2,22,222,etc, not 1,2,3,4,5. Question, how do I sort in numerical order and
not "computer" counting, is the answer in Access or the ordering button in
the DBRW, neither seems to work, thankyou
 
Hi Mick,

Sorting is sorting whether it is by computer or by hand. If you're getting that type of sort order it is because the database column
is character data and not numeric data. Change the column so that it is a numeric then it will sort by value.
 
Back
Top