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

G

Guest

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

Access Newbie - Access Formula/ expression for division with yes check box selected - Help 1
Access Microsoft Access Calculated Field - Expiry Date 0
Field hidden until yes/no box ticked? 4
Excel Excel Formula to calculate economy of a bowler (Cricket) 2
yes no true false tick toggle 1
Edit query from a form 2
Access MS Access Listbox not saving to bound field 0
how to calculate hrs flown in last one year 0

Top