Numeric Sort Order in Access2000

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I know I am a little late to upgrade, but I just upgraded
from 97 to 2003. Maybe I should've been aware of this,
but it seems that 2000 and 2003 sort alphabetically. I
need to sort my ten classes from 1 to 10. Is there an
easy fix? This sort shows up in grouping all over my
databse.
 
Scott said:
I know I am a little late to upgrade, but I just upgraded
from 97 to 2003. Maybe I should've been aware of this,
but it seems that 2000 and 2003 sort alphabetically. I
need to sort my ten classes from 1 to 10. Is there an
easy fix? This sort shows up in grouping all over my
databse.
Click to expand...

If you store numbers in a number DataType then Access will sort them as
numbers. If you use a Text DataType (even though you enter only numbers in
it) then Access will sort alphabetically.

This is not something that converting to a new version would have affected.
 
The numbers are a result from a Switch Command inside of a
query. I use the results to group several reports. In
97, the sort worked. It 2003, it does not.
 
The numbers are a result from a Switch Command inside of a
query. I use the results to group several reports. In
97, the sort worked. It 2003, it does not.
Click to expand...

Examine how the values are justified in the query datasheet. If they are
left justified then they are text and will sort as text. In that case just
wrap the expression with Val() to convert them to actual numeric values and
then they will sort as numbers.
 
Back
Top