[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

How do I count all the "True" values from a column that contains "True" and "False"

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.

TblDocumentation
Column names: DocId (Number), Diagnosis (Boolean), Problems (Boolean), Procedures (Boolean)

Summary Section:
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?

Thanks

Hiran
0
HiranB
Asked:
HiranB
1 Solution
 
HiranBAuthor Commented:
Hi,

I found the solution for this question in the knowledge base:

If {TblDocumentation.FlushLineOrederd} = True then
    1
else
    0
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now