On Wed, Sep 17, 2014 at 8: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? > > -------- I worry that invoices are out of date to be honest. Select ( field list) from table(s with any needed joins) Order by InvNumber, linenumber Forget the date part all together. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- 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/CAJidMYKca1Oh6TSwFcAUbZFpuDAi2hz3YDtkGjgtV_OAQN=q...@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.
