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
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