sorting

[Guest]

Hello.

I have a report that sorts in the usual way.
First Arnold, then Baldwin, then Calvin and so on.

Is there a way to make it sort differently?
The first letter for indiction would be enough.
Say like E***, then A***, then Z***.

Any ideas?

/Claes

 

[Duane Hookom]

You could set the sorting and grouping level to an expression like:
=Val(100 - Instr("ZAE",Left(LastName,1)))

 

[PC Datasheet]

Add an integer field named "SortOrder" to your names table. Enter numbers in
this field in the order you want to sort. Sort on the SortOrder field.