Sum of a calculated control

[mmethe]

Hello All,



I am must be missing something simple. I want to sum the values in a calculated field.

Gallons is a number
Price per gallon is currency
total is gallons x price per gallon (not stored, it is calculated on the report)

I want to SUM the TOTAL


I tried =Sum([total]) but is does not work. When I open the report I am prompted for that value

Any ideas?

Thanks,
-Mike M

[June7]

Aggregate functions must reference fields, not controls. So options are:

1. do the total calc in query and reference that constructed field

2. repeat the calc within the SUM() function: =Sum(quantity * price)