Summing up in a report (Access 2000)

[Markus]

Summing up in a report

I have a report called invoice but i cannot sum up the extended price of the products and i would like to ask for a help.My report is called invoice, and in the undrelying query i have a field
called ExtendedPrice with the following expression:

ExtendedPrice:CCur([OrderDetails].[UnitPrice]*[Quantity]*(1-[Discount])

/100)*100
and i works fine. The control in the report that has a record source Extended price is called Subtotal.It is placed in the Detail Section.In the section OrderIdFooter,of the report, where i am supposed to sum
the results,i have a control named InvoiceSubtotal.In the control source of the control named InvoiceSubtotal i have written the following
= Sum( [ subtotal] )
but i receive the following error:"Enter parameter value"

[Francois]

Marcus,

You should use :
= Sum([ExtendedPrice])

You are summing the field, not the control.

[MarkLiquorman]

I generally find Access reports work best when you do everything in the query. So, define a field in the query; in QBE grid, it would look like this:
ExtendPrice: Quantity*Price

In SQL statement, you would use Quantity*Price As ExtendedPrice.

You can then place ExtendedPrice onto your report in detail section, and use =Sum(ExtendedPRice) as controlsource of a field in footers.