calculated control in group and report footer

I have 10 amt fields and two checkbox fields in the detail section for each
record. I want to sum the amounts for each checkbox choice in the group
footer.

choice1-checkbox true, amt1=1.00
choice1-checkbox true, amt2=3.00
choice2 checkbox true, amt3=5.00

group footer total: total choice1=4.00
group footer total: total choice2=5.00

This doesn't work. I get the total for all amounts.

=IIf([choice1]=True,Sum(Nz([Amt1],0)+Nz([Amt2],0)+Nz([Amt3],0)+Nz([Amt4],0)+Nz([Amt5],0)+Nz([Amt6],0)+Nz([Amt7],0)+Nz([Amt8],0)+Nz([Amt9],0)+Nz([Amt10],0)),0)

You need to have a text box that sums each field. The way you have it set up
is if one checkbox is true, add all the other fields together. To get a total
of all Choice1, you need a textbox to sum choice1, to total all of choice2
you need a textbox to sum all of choice2 and so on and so on. The group
footer is the correct place to get the totals for each group. In control
source for each field you might use try =Sum([choice1]) and see how that
works. It works fine for me in my reports. Hope this helps!!

"Marianne" wrote:

I have 10 amt fields and two checkbox fields in the detail section for each
record. I want to sum the amounts for each checkbox choice in the group
footer.

choice1-checkbox true, amt1=1.00
choice1-checkbox true, amt2=3.00
choice2 checkbox true, amt3=5.00

group footer total: total choice1=4.00
group footer total: total choice2=5.00

This doesn't work. I get the total for all amounts.

=IIf([choice1]=True,Sum(Nz([Amt1],0)+Nz([Amt2],0)+Nz([Amt3],0)+Nz([Amt4],0)+Nz([Amt5],0)+Nz([Amt6],0)+Nz([Amt7],0)+Nz([Amt8],0)+Nz([Amt9],0)+Nz([Amt10],0)),0)