customizing the sorting of a query

[davikokar]

Hallo,
is there a way to customize the sorting order of a query if ascending or descending (numerical or alphabetical) are not the ones I would like? The situation: a field of the query will return country names (4 countries are included). I would like to sort the data by the country names but not in alphabetical or reverse alphabetical order... any ideas. Thanks

 

[SuicidED]

My attempt

Create a table with your 4 countries and have a field numbered 1,2,3,4 in the order you want them sorted. Join that table to your query and sort on the number.

 

[PHV]

In your query add a calculated column containing your sort key:
SortKey: IIf([country name]="country A",1,IIf([country name]="country B",2,IIf([country name]="country C",3,4)))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[davikokar]

mmm... could be a solution, but I was wondering if there is a way to do it through sql code...

 

[PHV]

To do it through sql code
What are the order choice criterias ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[davikokar]

I'll try your suggestion PHV, thanks. My last message was an answer to suicidED...