Sum of a sum field in a footer...

[Guest]

Is it possible to SUM a field which is itself a sum in the footer of a report?

The database I have is called Quotations, which is made up of Quotations and
Quotation_Details.

The report displays all Quotations and Quotation_Details relating to that
quote between 2 specified dates. Quotation_Details has the fields Quantity
and Price which I have multiplied together to create a field called
TotalCost, then for each quotation I get the sum of the TotalCost for each
item, this is saved to a field called
QuotationSum.

I want the sum of all the QuotationSum fields but all I get is an error.
The field QuotationSum is generated by =Sum([Quantity]*[Price])

But =Sum([QuotationSum]) simply displays an error. Any suggestions?

 

[Guest]

Hi, Richard.

Access allows you only to sum fields in the report's RecordSource, not
calculated ones. The solution is to refer to the component fields
themselves. Repeat your original calculation in the Report Footer:

=Sum([Quantity]*[Price])

Hope that helps.
Sprinks