Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi in the script itself do order by
load
avg,
high,
less
from table a
order by
avg,
high,
less;
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