Numbers

[caleb]

when i sort a collumn of numbers, par say
1,2,3,4,5,6,7,8,9,10,11,12,13,... and a sort it A->Z it
does it like
this...1,10,11,12...19,2,20,21...29,3,30,31... how do i
make it 1,2,3,4...9,10,11,12...19,20,21...????

 

[Kevin3NF]

Looks like your numbers are in a text field, not a number field...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Joseph Meehan]

when i sort a collumn of numbers, par say
1,2,3,4,5,6,7,8,9,10,11,12,13,... and a sort it A->Z it
does it like
this...1,10,11,12...19,2,20,21...29,3,30,31... how do i
make it 1,2,3,4...9,10,11,12...19,20,21...????

That happens because you are sorting characters (Text) not numbers.

Changing the field type to a number type will take care of that.
However it will also eliminate or error out any records that have letters
(like A, B, C..) or eliminate any leading zeros like 0012.

I suggest you copy the table and make the changes to the copy first to
make sure it all goes smoothly.