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 --- _______________________________________________ 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/CAG1nNy9Qn_q-LwqnE=o1SO4V2hd_uzV2c_EJ+9P9rP+JsSM1=a...@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.
