Total in report footer

J

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top