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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top