AnsweredAssumed Answered

Conditional sorting?

Question asked by RonOrmston on Sep 16, 2013
Latest reply on Sep 16, 2013 by philmodjunk


Conditional sorting?


     Is there a way of doing a conditional sort along the lines of:

     If field x is not empty sort this record using fields x & y, else sort using fields z & y ?

     What I want to do is sort fields alphabetically which begin with numbers by using their text equivalents (eg. 10 ABC sorts as Ten ABC) by using a second field with the text equivalent. This would account for <1% of my records so I'd like to avoid a complete duplication of my sort field merely to accommodate those few records.

     Thanks for any insight you can provide.