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

C

cainentm

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,
 
O

OfficeDev18 via AccessMonster.com

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,
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).
 
D

Duane Hookom

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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top