Total a group header field

[ddub]

Hi,

Is there a way to get a total for a field in a group header and put it in the report footer? I have a bound textbox called [FY1Amt] in the group header and in the report footer I have an unbound textbox with the control source as =Sum([FY1Amt]). I'd like to have the report add up all the [FY1Amt]fields for the groups and put the total into a textbox in the report footer.

Unfortunately, what seems to happen is [FY1Amt] gets multiplied by the number of detail records in that group and then added for the total. This results in my total being way higher than it should be. Any ideas on how I can get this to work?

Thanks,
ddub

 

[Shirley]

Have you set up the group footer, try putting the FYAmt as default = 1 in the footer, then in the report footer put the sum(FyAmt). Try this and see what you get.

 

[ddub]

Hi Shirley,

Can you explain what you meant by "as default=1" when you said to put the FY1Amt in the group footer?

Thanks.

 

[Shirley]

Set up a text box and set the defalut value = 1 and make the name of the Text box =FyAmt.