Sorting Database records

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
 
M

MD Websunlimited

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Results Filtering 6
How do I filter database results using an ASP 5
Sorting records in an Access table for real 2
DBRW Issue - Syntax Error 11
Numerical Sorting 1
Sorted Records in Report 2
complex sorting formula or macro needed 1
Sorting records within a subform based on two control fields 2

Top