What is the formula to calculate yes/no in a field in access?

T

Teenac

I have set up a database to enter information from a survey. Some of the
fields in the tables are yes/no with a tick box. I want to build a summary
report. What formula do I use to calculate the boxes that have been ticked
(yes)? I.e. Various departments are listed with tick boxes, I want to
calculate how many staff have ticked each department.
 
D

Duane Hookom

A yes/no field stores either -1 for yes/true or 0 for no/false. You can sum
them (possibly the absolute value or add 1) to get a count of the yes or no
values.
 

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

Split form 0
Creating a checklist with predefined comments 1
Resource Budget Cost - Tracking 0
How to have two tables on same line? 1
Select multiple text values and display in one field 3
Filtering and summing a calculated field on a subform 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Print report based on form selection 1

Top