Sum of sub Report

[rnutts]

Hi

I have a report with a sub report on it in the detail section of the main report. I wish to sum() one of the fields on the sub report but I am struggling.
This is the field I am trying to sum()
=rptEnquiryPaintCalc.Report!SumPaintCost
I have tried as
=SUM(rptEnquiryPaintCalc.Report!SumPaintCost)
and
=rptEnquiryPaintCalc.Report!SUM([SumPaintCost])
I am either asked by the report for the field name as a criteria or the result is #error when the report is run
I have tried the running sum setting on the properties.
I have tried to reference the field as a text box and then tried to sum the text box but again I am asked for the text box name as a criteria when the report is rum
I tried putting a sum() in the sub report report footer and then referencing this in the main reports report footer, but I just get value of the last record returned in the detail section of the main report

Any help greatly appreciated as this is driving me nutts

Thanks

Richard

 

[khawar]

Sum the field on sub report and then refer to that total field

 

[rnutts]

Ok thanks I tried this and the total came back as the last record returned in the detail section.
If I run the sub report outside on the main report ie on its own it works with the Sum() adding up all of the records, yet in the main report it only shows the last record

Anything further??