> I have a table which amongst other things has a field called salespers and > salesrev > I want to print the report in salesperson order, then salesrevenue > The sales person gose from 1 to 999 > How do I sort or index this table so that salespeople go from 1 to 999 but > sales from highest to lowest >
A) Assuming m.lx is the width of salespers and m.ly is the width of salesrev : INDEX ON PADL (10**m.lx-salespers,m.lx)+PADL(salesrev,m.ly) DESCENDING TAG yourtag (In your example, m.lx = 3 and probably m.ly = 9) B) Why create an index for a report ? You better select the right set in the right way, like : SELECT salespers, salesrev FROM yourtable ; ORDER BY salespers ASC, salesrev DESC ; INTO CURSOR yourresultset Gérard. ____________ Analysé par G DATA AVK Version : AVK 18.4496 de 15.07.2008 Informations sur les virus : www.antiviruslab.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
