How to get the Sum of values from a Calculated field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a calculated field (we'll call it "OQL Total") in my report that pulls
its variables from other fields in the report. The calculations are fine for
each record in the group. Now I need to get the Sum of all of these
calculated "OQL Total" values into the Group footer. I have created a text
box in the footer with the controlsource set to =Sum([OQL Total]), but when I
run the report I get prompted to enter the "OQL Total". It appears as though
it does not like to calculate based on a calculated field. Any ideas?
Using Access 2000.
Thanks,
 
cainentm said:
I have a calculated field (we'll call it "OQL Total") in my report that pulls
its variables from other fields in the report. The calculations are fine for
each record in the group. Now I need to get the Sum of all of these
calculated "OQL Total" values into the Group footer. I have created a text
box in the footer with the controlsource set to =Sum([OQL Total]), but when I
run the report I get prompted to enter the "OQL Total". It appears as though
it does not like to calculate based on a calculated field. Any ideas?
Using Access 2000.
Thanks,
Click to expand...
If the field is OQL, the text box in the detail section should be OQL. In the
Group footer, the formula is =Sum(OQL). Even in the Report Footer section,
the formula remails = Sum(OQL).
 
Clarification, you have a calculated "control", not "field". You can't sum
controls. You can sum expressions involving fields from your report's record
source. You might need a control source like:
=Sum([Quantity] * [UnitPrice]-[Discount])
 
Back
Top