Summing True / False values in report

[grenee]

Good Day all,

I have a field "present" of data type yes/no, and I want to count the number of values that are yes ( which are the ticks ).

I tried the following but it does not work: Count [present]

The report contains groups of records which I would like to sum separately.

Can anyone assist?

 

[arnelgp]

=Count(IIf([present]=True, 1, Null))

 

[grenee]

Thanks for your response.

Unfortunately it hasn't work for me. I tried over and over.

Are there any other suggestions?

 

[sneuberg]

I think this depends on where you want this. You could try something like:

=DCount("[present]","[Table1]","[present] = True")

if you want is it in the report header as done in the attached database. You need to change Table1 in this to your table or query name.

 

[grenee]

Dear arnelpg I am so sorry and embarrassed to tell you that all your suggestions are working. I discovered a hidden problem: my record source is a Dynaset and the join of my table was causing an increase of records for that record set which would obviously be more that the table. I had 2 choices; either use the table directly or reconfigure my joins at the query level. I tried both and the worked with your first and second formulae. Thanks for burning you time.