How Does One Add a Total to a Report Footer?

[Chinyere]

Hi There ,

What I am trying to do is add the Total (code below) to the report footer but I keep getting an error message. When I place it in the body (detail area) of the report it works but it repeats with the other records. What's a girl to do?

Is there a way to place it at the bottom of the body of the report without it repeating with every record? OR
Is there a way to put it in the footer and have it actually work?

=Abs(Sum([table].[First_Participant]=True And [table].[Attn_02]=True))
[code]

I am working on a project and need help ASAP.

Thanks!
Chinyere

 

[pdldavis]

Hi, leave the text box in the detail section. Turn its properties to invisible and set it to sum over the group, assuming you want to sum up the attendees. I usually turn the font Red so I know it's an invisible box.
The control source for the text box in the footer will be the name of the previously mentioned text box in the detail section: =txtAttendees fro example.
That should do it for you.

 

[Chinyere]

Thank you pdldavis!

I will give it a try.

Chinyere