the results I get are currently something like this:

Sales Order NumberAccount NumberLines Per Order

19319-02711

17987-02711

19148-02711

19052-02711

19052-12711

19545-02711

19564-02711

19704-02711

19030-02711

19661-02711

19662-02711

19662-12711

SO-4343 271 3

SO-4313 271 1

See...

I actually had over 1000 sales orders so adding them individually would be a pain but Sean, thank you so much! Your count(invoice) section did the trick. I just changed...

Sorry about that, this is an idea of what I have:

Sales Order #InvoiceIDInvoiceDate InvoiceAmount

SO-100 INV-382224/12/2013 ...