Using Calculated Text Box Values in Report Footer Calculations

[WillW]

In my report's Detail lines, I include several Text Boxes that contain values
calculated from other detail Text Boxes. How do I access these calculated
Text Boxes in my Report Footer to use in additional calculations there --
e.g., =sum([txtCalcValue]) where txtCalcValue contains calculated values in
Detail?

When I try this and run my report, Access asks me to Enter Parameter Value
(txtCalcValue).

Thanks in advance.
Bill

 

[John Spencer]

You either need to find a way to do the calculations in the query or redo the
calculations in the footer. For instance,

In the detail if you have a control named "extendedCost: with the calculation
=Cost * quantity
You would need to a control in the report footer (totalExtendedCost) as
=Sum(Cost*Quantity)

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County