Sorting Text Field with dashes

[terryh70]

I have a text field that contains the following values and sort in this order

138-1
138-10
138-11
138-12
138-2
138-20
138-21
138-22
138-3
138-4

I would like to have it sort this way

138-1
138-2
138-3
138-4
138-5
138-10
138-11
138-12
138-13
138-20
138-21
138-22

 

[fredg]

I have a text field that contains the following values and sort in this order

138-1
138-10
138-11
138-12
138-2
138-20
138-21
138-22
138-3
138-4

I would like to have it sort this way

138-1
138-2
138-3
138-4
138-5
138-10
138-11
138-12
138-13
138-20
138-21
138-22

In the report's Sorting and Grouping dialog:
View + Sorting and Grouping
as the first Field/Expression line write:

=Val(Left([FieldName],InStr([FieldName],"-")-1))
Ascending

On the next Field/Expression line, write

=Val(Mid([FieldName],InStr([FieldName],"-")+1))
Ascending