J
John
I have a main report "rptInvoice" and a subreport "rptInvoiceSubreport".
The subreport has three fields taken from a query. UnitPrice Quantity and
ExtendedPrice. I want to total the ExtendedPrice fields from the subreport
in the report footer of the main report.
I have tried =Sum([rptInvoiceSubreport]![ExtendedPrice])
and =Sum([rptInvoiceSubreport]![UnitPrice]*[rptInvoiceSubreport]![Quantity])
Each time I get a dialog requesting a parameter value. Can anyone tell me
where I'm going wrong.
Any help greatly appreciated.
John
The subreport has three fields taken from a query. UnitPrice Quantity and
ExtendedPrice. I want to total the ExtendedPrice fields from the subreport
in the report footer of the main report.
I have tried =Sum([rptInvoiceSubreport]![ExtendedPrice])
and =Sum([rptInvoiceSubreport]![UnitPrice]*[rptInvoiceSubreport]![Quantity])
Each time I get a dialog requesting a parameter value. Can anyone tell me
where I'm going wrong.
Any help greatly appreciated.
John