Sum of calculated field

  • Thread starter Thread starter SteveP
  • Start date Start date
S

SteveP

I have 3 columns on a report - UnitCost, Quantity, and Credit (calculated on
the report as "=[UnitCost]*[Quantity]"). What I am trying to do is add a
text box in the report footer that gives me a total of the "Credit" field.
Could some one please help me with this. Thanks in advance for any help.

SteveP
 
SteveP said:
I have 3 columns on a report - UnitCost, Quantity, and Credit (calculated on
the report as "=[UnitCost]*[Quantity]"). What I am trying to do is add a
text box in the report footer that gives me a total of the "Credit" field.
Could some one please help me with this. Thanks in advance for any help.
Click to expand...


Since the aggregate functions (Count, Sum, etc) are unaware
of controls, you need to Sum the original expression:
=Sum([UnitCost]*[Quantity])
 
That worked. Thank you very much.
SteveP

Marshall Barton said:
SteveP said:
I have 3 columns on a report - UnitCost, Quantity, and Credit (calculated on
the report as "=[UnitCost]*[Quantity]"). What I am trying to do is add a
text box in the report footer that gives me a total of the "Credit" field.
Could some one please help me with this. Thanks in advance for any help.
Click to expand...


Since the aggregate functions (Count, Sum, etc) are unaware
of controls, you need to Sum the original expression:
=Sum([UnitCost]*[Quantity])
Click to expand...
 
Back
Top