calculating totals involving subreports (1 Viewer)

[connieharper]

Access97: I have a report (Progress_Report) that contains a subreport (Progress_Report_Grades_system) and wish to add totals from a field on the main report and a field on the subreport together for a grand total but am having problems. I am using this source code on the GRANDTOTAL text box to try to get the total but when I run the report I get an error that the subreport (progress_report_Grades_system) does not exist.

Main Report Text Box (GrandTotal2)

source = Report([Progress_Report_Grades_system].[gradetotal]+[text30])

I suppose my syntax is wrong but have tried numerous variations with no positive result.

Details are below:

On the Main Report I have a text box named [Text30] that contains a value calculated by this expression: source= (avg([Grade]*100)*[weight]/100*100)

On the subreport I have a text box named [GrandTotal] that contains a value calculated by this expression: source= (avg[Grade]*[Weight]/100*100)

I appreciate any help.