By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,658 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,658 IT Pros & Developers. It's quick & easy.

Problems with summary reporting

P: 76

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.

Feb 9 '09 #1
Share this Question
Share on Google+
5 Replies

Expert 100+
P: 1,923
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.
Feb 9 '09 #2

P: 76
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?
Feb 9 '09 #3

Expert 100+
P: 1,923
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.
Feb 9 '09 #4

P: 76
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.
Feb 9 '09 #5

Expert 100+
P: 1,923
<<<Where the formula Sum([DDMS Items]) is what is in the control box >>>
Should be: = Sum([DDMS Items]) 'need the = sign
Feb 9 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.