Custom Sort Order

[ToddK]

I have data strings that look like this:
1Y, p.6
1Z, p.8
1AA, p.92
1AB, p.76

When I create a report that outputs these strings, it sorts them alphabetically, so that I get:

1A, p.1
1AA, p.92
1AB, p.76
1B, p.4
1C, p.8

I want to define a custom sort order to get the double-letters to sort after single letters.

Anyone help?

 

[smozgur]

Use a query instead directly using table as data source of your report (or just apply my suggestion if you are already using a query)

Add one more field into your query and make it first field in order. That field should be Len(Field1) (Field1 is the one you want to run sort) and select Ascending Order for sort in Query. Also set Ascending Order for Field1. Just be careful that new field should be located before the Field1 in Query.

This will basically sort field by lenght of the text and then by letters then it will be like:

1A, p.1
1B, p.4
1C, p.8
1AA, p.92
1AB, p.76

I hope this helps.

Regards
Suat

Edited : Used original sample data given in thread.
This message was edited by smozgur on 2002-12-24 06:51