G
Guest
Hello All,
I have a report that has a subreport. This subreport has one level of
grouping. I have a text box (let's call it Text1) that I want to sum on the
footer of level1 (which is, of course, below the detail section.) I have
another text box (Text2), whose control source is Text1, with sum equal to
"Over All". Now, there is a Text3, in the main report, which then references
Text2. The Problem: Text3 grabs the first value of Text2, not the sum. For
example, if Text2 were summing up 100, 200, 300, and 400, I want 1600; what
it gives me is 100. HELP!! Please! I've actually set up a fourth text box
in the report footer of the subreport equal to Text2 - this new text box
gives exactly what I want, but referencing it in the main report didn't help.
Does anyone know? I've been trying to build this thing for a week, and I'm
losing my patience (and possibly my job ...)
I have a report that has a subreport. This subreport has one level of
grouping. I have a text box (let's call it Text1) that I want to sum on the
footer of level1 (which is, of course, below the detail section.) I have
another text box (Text2), whose control source is Text1, with sum equal to
"Over All". Now, there is a Text3, in the main report, which then references
Text2. The Problem: Text3 grabs the first value of Text2, not the sum. For
example, if Text2 were summing up 100, 200, 300, and 400, I want 1600; what
it gives me is 100. HELP!! Please! I've actually set up a fourth text box
in the report footer of the subreport equal to Text2 - this new text box
gives exactly what I want, but referencing it in the main report didn't help.
Does anyone know? I've been trying to build this thing for a week, and I'm
losing my patience (and possibly my job ...)