help with sort order

[Anonymous]

Hi,

I have 70 fields with fields values

avg,

high,

less

but i want the sort order as

high,

avg,

less

i can write a sort expression like Match(filedname,'high','Avg','Less') but this expression has to be written in all 75 list boxes (which i think will have lot of performance issue)

and i can have inline sort order table but i have around 75 fileds which needs to be sorted.

Any optimal and ideal solution please ?

[shree909]

Hi in the script itself do order by

load

avg,

high,

less

from table a

order by

avg,

high,

less;

[Anonymous]

thanks for the reply shree..

but there are fields values like

fieldname - likelihood of purchasing a vechicle

and field values are like this

avg,

high,

less