Using Calculated Text Box Values in Report Footer Calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WillW - 16 May 2008 15:16 GMT

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

Reply to this Message

John Spencer - 16 May 2008 16:56 GMT

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

> 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
[quoted text clipped - 7 lines]
> Thanks in advance.
> Bill

Reply to this Message