Sum of calculated field

[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

 

[Marshall Barton]

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.

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

 

[SteveP]

That worked. Thank you very much.
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.

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