I am very thankful, injust a few minutes i got my answer & its doing exactly what i wanted.
Duvid
>
INDEX ON Lastname + IIF( LEFT(firstname,1)="K", "1", "2") ...
>
>>i want to create an index that should sort in the following order:
>>
>>Example:
>>
>>"Lastname" + all firstnames that start with lets say "K" should be on the top and the others should be under "K" in any order.
>>
>>i hope its clear.
>>
>>any help would be highly appreciated!