Sort order of report problem

[Carlee]

Hi there,

I have a report that has numeric data as well as number/text data in text fields. When i sort ascending i want to have the numeric data shown as 1,2,3,4 etc....what I get is 1,10,11,100.

How can i fix this so i get the proper sort of 1,2,3,4

many thanks in advance,

Carlee

 

[Marshall Barton]

I have a report that has numeric data as well as number/text data in text fields. When i sort ascending i want to have the numeric data shown as 1,2,3,4 etc....what I get is 1,10,11,100.

How can i fix this so i get the proper sort of 1,2,3,4

The problem is that you have "numeric" data in a text field.
Text data is supposed to sort the way you're seeing it.

A quick and dirty way around this situation is to sort on an
expression such as CLng([thefield])