Counting Checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database, I am using checkboxes and on my reports i am
getting a negative number. Is there a way to only count the Checkmarks?
 
A checkbox returns True or False (Null is also possible). Access and VBA
treat True as -1 and False as 0. This should be where you're negative number
is coming from. The Absolute Value of that should be the answer you're
looking for. You can either use the Abs() function or multiply by -1.
 
If that's your real e-mail address, you may want to reconsider making it so
available. If it is a real address, you are inviting mountains of spam, not
from the people who post here, but rather from people who use programs that
mine e-mail addresses from public forums.
 
I ended up finding this on the site, and it does seem to work...

=Sum(IIf([Active Duty Death]=True,1,0))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting ticked check boxes 1
Problems with Copied File 2
Count check box yes/no 2
Printing Problems involvong columns with checkboxes 1
Using the =Count Expression 5
Auto Assign Checkboxes in Excel 2007 2
Checkbox Problem 2
Checkbox visible on Report only when checked 6

Back
Top