Totals in subreports

[Moira Triance]

I'm sure this can be done but I must have my syntax wrong. I have a report with 1 subreport and that subreport has a subreport which lists products and their prices. In the footer of the bottom level subreport I have a calculated control called
TempCCost =Sum([Price]). Here's the thing: I want to total that sum figure into the footer of the main report. Each time I do it I am get a prompt box asking me to enter the figure. Here is my syntax:

=Sum([Reports]![rpJobSheet]!rpJobSheetSubform!rpCopyFormatSubForm!Reports.[TempCCost])

Any help would be greatly appreciated.

 

[Rich]

You can't Sum a calculated control in this way, you'll have to repeat the calculation in the footer =Sum([Price])Or Sum it in the sub report footer and refer to the actual control on the main report footer.
([Reports]![rpJobSheet]!rpJobSheetSubform!rpCopyFormatSubForm!Reports.[TotalSummedFieldControlName]