Problems with summary reporting

[ckpoll2]

Hello.

I have set up a report where the sum of counts of different item types are displayed in alphabetical order. Since I need to add certain ones together, but not get a complete grand total, I am trying to put text boxes together in the report footer with IIF statements, which I will then add certain boxes together to get the totals. What I have so far is...

=IIf([Item Type]="Blitzes",[Sum Of DDMS Items],"0")

Where Blitzes is the type. I'm trying to get it to display the [Sum of DDMS Items] Text Box if the type is Blitzes and display 0 if it is not. This way, I can add this text box to the one that is showing all of another item type to get that total. What am I doing wrong?

Thanks for your help.

Chuck

[puppydogbuddy]

1. remove double quotes around the 0
=IIf([Item Type]="Blitzes",[Sum Of DDMS Items],0)
2. Is the [Sum Of DDMS Items] the name of a textbox holding a calc? If it is a calc field, I believe you need to repeat the calc (control source), not the name.

[ckpoll2]

Thanks for looking into my problem.

I removed the double quotes, but that didn't seem to do it. I'm not sure what you mean by repeating the calc (control source). Can you type out what the formula should look like for me? I'm not very good at working with access. The [Sum of DDMS Items] is the name of the text box that is holding the calculation of the sum of all the individual listings of the items.

Does that help?

[puppydogbuddy]

in this context, you can't refer to a calc field by name; you must refer to it by the contents shown in its control source property...which is the calculation, itself.

So, relace [Sum of DDMS Items] with the actual calculation formula for the sum of all the individual listings of the items.

[ckpoll2]

That didn't seem to take care of it. I have in the text box:

=IIf([Item Type]="Blitzes",Sum([DDMS Items]),0)

Where the formula Sum([DDMS Items]) is what is in the control box and still no luck. Any other ideas? I feel like I'm really close, but just missing one crucial part of it.

Thanks for continuing to help.

[puppydogbuddy]

<<<Where the formula Sum([DDMS Items]) is what is in the control box >>>
Should be: = Sum([DDMS Items]) 'need the = sign