I have a result set that was created from joining two tables. The result set was created in some third party software so I can not change the Query.

I am using the first footer band as the detail band (cust#+order# below). Now i want my second footer to sum the amounts that are in the first foot, not to sum the detail record amounts.

thanks

brenda

cust# order# order_tot item#
12345 4444 100.00 331
12345 4444 100.00 332
12345 4455 40.00 787
12345 4455 40.00 787
32434 4322 20.00 656

I want the report to be

12345 4444 100.00 2
12345 4455 40.00 2
------- ----
140.00