Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Total a group header field

Status
Not open for further replies.

ddub

MIS
Jul 9, 2002
17
US
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
 
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. :)
 
Hi Shirley,

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

Thanks.
 
Set up a text box and set the defalut value = 1 and make the name of the Text box =FyAmt.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top