Report sorting numbers wrongly

[Tremor]

Hi there.

I have a report which is working great apart from one problem. I have ot grouping by CustomerName which is fine, then I want it to sort by NoOfDays.
Now, it does this, but it treats 9 as higher than 20, for instance. It only seems to be sorting on the first digit of every number.

Any ideas?

Thanks, Paul

 

[KenHigg]

You get it to work by wrapping it in a cint() function.

 

[SOS]

Hi there.

I have a report which is working great apart from one problem. I have ot grouping by CustomerName which is fine, then I want it to sort by NoOfDays.
Now, it does this, but it treats 9 as higher than 20, for instance. It only seems to be sorting on the first digit of every number.

Any ideas?

Thanks, Paul

1. If NoOfDays is Text then it will sort by the TEXT value and not numeric value.

2. If it is numeric, then you probably haven't added a sort on that field in the Report Sorting And Grouping (it will not keep sorts from the query).