Totalling a value in a group header only 1

[btalon]

I'm wanting to sum a value in the group header on the footer of the report without grabbing the same info in the detail. So when the info for the header prints, I want to add one of the header values to the running total. I tried it with code and it works fine until the report creates the next page and then the total gets messed up. Is there another way to just sum whats in a group header?

 

[dhookom]

If I understand correctly, you can set the Running Sum of the text box in your Group Header to Over All. Then add a control in your Report Footer with a control source of:
=[NameOfTextBoxInGroupHeader]

Duane
MS Access MVP

 

[btalon]

Thats works great!! Thanks.