Sorting Text Field with dashes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

terryh70 - 27 Mar 2008 21:18 GMT

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

Reply to this Message

fredg - 27 Mar 2008 21:50 GMT

> I have a text field that contains the following values and sort in this order
>
[quoted text clipped - 23 lines]
> 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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message