troubleshooting Question

Count Yes/No and show total on Report

Avatar of bryanscott53
bryanscott53Flag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Access
23 Comments1 Solution333 ViewsLast Modified:
Hi everyone, I am using access 2010.

I have a field called April 2011, it is a Yes/No tick box. I have created a report with this field in and I wanted to sum all of the ticks (Yes answers). I searched online and found this; =Abs(Sum([April 2011])) but I just get an error (I am using a text box and inputing this formula into the control source). does anyone know why this oesnt work?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 23 Comments.
Join the Community
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 1 Answer and 23 Comments.
Try for 7 days

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

-Mike Kapnisakis, Warner Bros