How do I count all the "True" values from a column that contains "True" and "False"
Posted on 2009-07-12
Hi, I am working with a table with several columns that contain "True" and "False" values. The table name is TblDocumentation. I need to be able to have a summary section that counts the number of occurences of "True" for each column.
Column names: DocId (Number), Diagnosis (Boolean), Problems (Boolean), Procedures (Boolean)
Number of Diag completed = Count(Diagnosis) when True
Number of Problems completed = Count(Problems) when True
Number of Procedures completed = Count(Procedures) when True
There are no groups required for this report at the moment. How do get these counts to work?