... ORDER BY invnum, date This takes the result set and puts them in order by Invoice number and within that by date. If you're creating a result set for all the clients, perhaps you'd add the clientnumber as the first of the three arguments.
On Wed, Sep 17, 2014 at 9:40 PM, 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? > > > -- > Kind regards, > Sytze de Boer > Kiss Software > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ 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/CACW6n4tb73cLxTVzTeicK2AjKTjLKsNww39RkMkh60q_-ha=s...@mail.gmail.com ** 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.
