Sort order of report problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Carlee said:
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
Click to expand...

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])
 
Back
Top