Total in report footer

[jesseb]

I have =sum([inv_amt]) in my page header.
I want to take the total on each page/group and total it in the report footer.
The below reads like it is the answer, but the problem (if it is correct) is
how do I bound a text box to a field?
Now if the below is not correct can someone tell me how I can place a total
in the report footer for my total in the header?


1. Create a text box in the detail section, and bound it to the field you
want to sum
2. Set the RunningSum property of that text box to OverAll
3. Set the Visible property of the text box to No
4. Create a text box in the Report PageFooter and in the control source write
=[TextBoxNameFromStage1]

Thanks, Jesseb

 

[Gina Whipp]

Jesseb,

Is [inv_amt] in the detail section (See item 1.,which points to the Detail
Section)? If not what is in the Detail section?

To answer your question, you create a Text Box and as the ControlSource you
put inv_amt.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have =sum([inv_amt]) in my page header.
I want to take the total on each page/group and total it in the report
footer.
The below reads like it is the answer, but the problem (if it is correct) is
how do I bound a text box to a field?
Now if the below is not correct can someone tell me how I can place a total
in the report footer for my total in the header?


1. Create a text box in the detail section, and bound it to the field you
want to sum
2. Set the RunningSum property of that text box to OverAll
3. Set the Visible property of the text box to No
4. Create a text box in the Report PageFooter and in the control source
write
=[TextBoxNameFromStage1]

Thanks, Jesseb