I have a select query that adds up monthly sales for products both by case
and single items for a commission report. An example would be:



Widget A
Single Qty
Single Cost
Total
Case Qty
Case Cost
Total
Grand Total


1
.99
.99
2
5
10
10.99

Widget B
1
.50
.50
1
5
5
5.50








16.49




I need to total the monthly sales at the bottom of the report, but right now
I get the whole total for both products. IE: Widget A $16.49 Widget B $16.49
which gives me a total of $32.98. The more products on the invoice, the more
duplicate totals and bigger grand total at the bottom. I need to have it add
up the total for the entire invoice once per invoice number in the report
footer. I thought about using a sub query, but I can't figure out how to do
it. Anyone have any suggestions?

Thanks



Jim