Try Again - Referring to Report Text Boxes

[Mike Thomas]

I am going to repost this - I think I was not clear enough on my first
posting.

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([report].[CILttl]-[report].[CILCar]-[report].[CILCum]-[report].[CILAdv]
)

Where CILttl, CILCar, CILCum, CILAdv are the names of text boxes in a GROUP
FOOTER (eg a different band than the report footer). They themselves are
the result of complicated calculations on the
data in the detail band.

In the above example using the SUM() function, when I open the report it
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.

How can the line above be modified to be modified to
display the correct total of the values in the text boxes above?

Many thanks
Mike Thomas

 

[Wayne Morgan]

See if this will work. Create a copy of each of the textboxes (with the same
equations) in the group footer and set their visible property to No. Set the
running sum of these new textboxes to OverAll. Set the textbox in the Report
Footer to these new textboxes.

=HiddenCILttl-HiddenCILCar-HiddenCILCum-HiddenCILAdv

I assume you were trying to subtract one from the other since you had the
dashes in your current equation.

 

[Mike Thomas]

Many thanks, Wayne - I had definitely not thought of that solution.

Mike Thomas