Hi All

I have a database where one of the fields is yes or no. I want to be able to have a field that tells me how many are yes. Any suggestions welcome

- Ninox partner
- RoSoft_Steven.1
- 5 yrs ago
- Reported - view
cnt(select Tablename where YesNoField = true)
- steveharratt
- 5 yrs ago
- Reported - view
Thank you for a speedy reply, but sadly that might as well be in Chinese to me, I will research it Thanks
- Choices_Software_Dean
- 5 yrs ago
- Reported - view
Paste what Steve has provided into a formula field, and substitute your table name and your yes/no field name. For example, with default names, it would look like: cnt(select Table1 where 'Yes / No' = true)

Alternatively, you could click the column header of your yes/no field and click "Count".
- steveharratt
- 5 yrs ago
- Reported - view
Thank you so much, it I think has clicked into place, very many thanks, I have learnt so much in the las few hours

Content aside