troubleshooting Question

# Report formula issue (Sum(iif(...)))

asked on
Microsoft Access
24 Comments3 Solutions816 ViewsLast Modified:
Is there a limitation to the number of sum(if..)'s in a report grouping footer?  There are 10 that I need to do, but it fails when I create 9 and/or 10.  When I delete all but 8 it works fine.  It doesn't matter which 8 are left, so it isn't any one in particular.  Does anyone know if this is a ruleset?

=Sum(IIf([Field1]="Y",1,0))
=Sum(IIf([Field2]="Y",1,0))
=Sum(IIf([Field3]="Y",1,0))
=Sum(IIf([Field4]="Y",1,0))
=Sum(IIf([Field5]="Y",1,0))
=Sum(IIf([Field6]="Y",1,0))
=Sum(IIf([Field7]="Y",1,0))
=Sum(IIf([Field8]="Y",1,0))
=Sum(IIf([Field9]="Y",1,0))
=Sum(IIf([Field10]="Y",1,0))
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 24 Comments.
###### Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 24 Comments.

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.