sorting

C

Claes D

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
 
D

Duane Hookom

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

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.
 
Top