sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You could set the sorting and grouping level to an expression like:
=Val(100 - Instr("ZAE",Left(LastName,1)))
 
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.
 
Back
Top