Yes/No

[RhondaStockton]

Hi there
Please could you let me know how I can count the number of tick boxes ticked in a table?
Thank you

 

[Norie]

Create a query with the field containing the tick boxes twice. Choose Totals and set the total for one to Group By and the other Count.

This should give you a count of both ticked and non-ticked boxes.

In SQL:

SELECT Table1.CheckBoxField, Count(Table1.CheckBoxField) AS CountOfCheckBoxField
FROM Table1
GROUP BY Table1.CheckBoxField;