Numbers

[Guest]

How can I cause a field to correct the number order??
example;

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20

instead of;
1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,25,26,27,28,29,3,30

the only way i can get it done is to put a leading zero..

Thx

 

[Douglas J. Steele]

Sounds as though your field is text, not numeric.

Can you change the field type?

If not, try using the Val function in a computed field in your query, and
sort on that.

 

[Joseph Meehan]

How can I cause a field to correct the number order??
example;

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20

instead of;
1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,25,26,27,28,29,3,30

the only way i can get it done is to put a leading zero..

Thx

There are number and there are characters like 1,2,3...)

You have characters because it is a text field. You can change the
filed type to numbers and then the will be sorted in numeric order rather
than character (alpha) order.

 

[Guest]

Hi Bobcat,

If the data is only numeric, as the example you gave, then the easiest way
to get a sort to work properly is to change the data type from Text to
Numeric.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

How can I cause a field to correct the number order??
example;

1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20

instead of;
1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,25,26,27,28,29,3,30

the only way i can get it done is to put a leading zero..

Thx

 

[Guest]

I feel a DAH moment, change it to numeric

id10t error

Thx

 

[Guest]

Also known as a PEBCAK error <smile>

(Problem Existing Between Chair and Keyboard)

You're welcome.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I feel a DAH moment, change it to numeric

id10t error

Thx