My Cost Analysis Report is

JobID Invoice Description Qty Cost TotalCost

MERRIF 8/3/02 BORDER 12 $4.00 60.
MERRIF 8/3/02 BORDER 15 $4.00 48.
MERRIF 9/5/02 CAPFIT 122 $3.00 96
MERRIF 3/6/02 CAPFIT 63 $5.00 32

The report is sorted by Description and invoice date
In the design view;
There is subform (rpt.JobCostAnalysis:Header) in header section
And in details section there are three sub forms and in footer two sub forms
Now I need is sub totals:

MERRIF 8/3/02 BORDER 12 $4.00 60.
MERRIF 8/3/02 BORDER 15 $4.00 48.
SubTotals 108
MERRIF 9/5/02 CAPFIT 122 $3.00 96
MERRIF 3/6/02 CAPFIT 63 $5.00 32
SubTotals 128
I tried by creating footer controls and used concatenation. It is not working.