counting true/false fields

C

chk

I have a table I am using in a report with unbound controls to show counts of
various true/false fields in the table. I have a field called
tblProcedureCapture_RAA #2 and I am trying to count when it is true. I have
tried DCount, Abs(Sum([tblProcedureCapture_RAA #2]),
Sum(IIf([tblProcedureCapture_RAA #2],1,0)) and none of them work. I get #
error or a -1 as a response. What am I doing wrong. I will also need to add
on some or and and statements to this true count - any thoughts?
 
D

Duane Hookom

Generically, you can use:
=Sum( Abs([Your True/False Expression]) )
To count the number of records in a report where the [Active] field is true,
you can add a text box to the REPORT footer with a control source like:

=Sum( Abs([Active]) )

Do you really have a field name that begins with "tbl" or is this a typo?
 
Top