Advanced Sort

  • Thread starter Thread starter Cath
  • Start date Start date
C

Cath

Hi,
I am trying to sort some data in a report. What I am trying to do is for
exemple, I have these datas: 10056, 10048, 10071, 10025

I want to sort in ascending order but by the 4th number, like this:

10025
10048
10056
10071

Is it possible?

Thank you
 
The examples which you provided will sort the same way normally OR by the 4th
number.
 
Hi,
I am trying to sort some data in a report. What I am trying to do is for
exemple, I have these datas: 10056, 10048, 10071, 10025

I want to sort in ascending order but by the 4th number, like this:

10025
10048
10056
10071

Is it possible?

Thank you
Click to expand...

In a report?
Do you wish to sort on
1) just the 4th character alone?
or
2) from the 4th character onward?

In Report Design View click
View + Sorting and Grouping

1) set the first level Field/Expression to:
=Val(Mid([FieldName],4,1))
Ascending

The above will sort just by the 2,4,5,7 value.
10025 will sort before 10048 but 10025,10024, and 10026 will sort
without any specific order within the 2's.

2) set the first level Field/Expression to:
=Val(Mid([FieldName],4))
will sort the 10024, 10025, 10026 in correct order within the 2's.
 
Back
Top