SQL query for sales history report

[felix114]

Thanks Phil,
I just looked at the report you suggested and it works pretty well. I just need the column totals to be separated by period instead of summed up. I'll study it and see if I can get it to work exactly how I need it to.

Thanks Tim,
This is along the lines of the kind of advice I'm looking for. I'm just learning php and sql as I go so any steer in the right direction is helpful.
I made the change you suggested, but the problem still remains.

The main issue I'm having is that the invoice totals seem to be multiplied by the number of line items there are. I'll see what I can learn from the report Phil suggested and go from there.

Regards,
Felix