On September 17, 2014 9:40:47 PM EDT, Sytze de Boer <[email protected]> wrote: >With a customised option to print monthly statements, I need to do the >following > >1 I need to have all the entries for the client ordered by invoice >number >2 but also in date order > >(Date are set british) >Example >Date Invnum Qty Amount Desc >21/7/2014 1000 1 1000.00 1st line on invoice >21/7/2014 1000 1 45.00 2nd line on the >invoice >(There may be 20 lines) > >14/7/2014 1001 1 5000 Invoice line 1 >14/7/2014 1001 2 34 Line 2 > >I want invoice 1001 to come before 1000, for date order >I can't get my head around this >Can anyone help?
The quick answer is to index on padl(invoice)+dtos(date) -- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
