Referring to Report Text Boxxes in a Different Band on Same Report

[Mike Thomas]

In an Access 2000 report, in a text box in the report footer band called
CILTotal, I am trying trying to do the following:

=Sum([CILttl]-[CILCar]-[CILCum]-[CILAdv])

CILttl, CILCar, CILCum, CILAdv are the names of text boxes in a group
footer. They themselves are the result of complicated calculations on the
data in the detail band.

In the above example using the SUM() function, the report asks me to input
these 4 values when it opens - eg it cannot find them. If I drop the SUM(),
and change the data property in CILTotal to sum across all, the field
displays an empty value in the report.

Using me.CILTtl did not work.

How can "=Sum([CILttl]-[CILCar]-[CILCum]-[CILAdv])" be modified to
display the correct total?

Many thanks
Mike Thomas

 

[SA]

Mike:

If all the values are in controls in the footer, you don't need the Sum()
function (which is designed to work on the value of one specific field).
Rather simply have your control source
=(Report.[CILttl]-Report.[CILCar]-Report.[CILCum]-Report.[CILAdv])

HTH