In Report Count "YES"

  • Thread starter Thread starter Ady
  • Start date Start date
A

Ady

Hi There

I have a report that lists many rows of Welsh3000 as either YES or NO. In
the report footer I wish to total up all of the "YES". I have tried SUM and
COUNT and DSUM and DCOUNT but I am getting nowhere.

Any help offered will be most appreciated.

Thank you in advance.

Ady
 
Ady said:
Hi There

I have a report that lists many rows of Welsh3000 as either YES or
NO. In the report footer I wish to total up all of the "YES". I have
tried SUM and COUNT and DSUM and DCOUNT but I am getting nowhere.

Any help offered will be most appreciated.
Click to expand...

Is it a Yes/No field or a Text field containing "Yes" and "No" strings?

The Yes/No DataType store true as negative one and false as zero so the
following will give you the count of Yes records...

=Abs(Sum([FieldName]))

If you are using a Text field then...

=Sum(IIf([FieldName]="Yes",1,0))
 
The formula you suggested:
=Sum(IIf([FieldName]="Yes",1,0))

Was successful!

Many thanks!

Ady



Rick Brandt said:
Ady said:
Hi There

I have a report that lists many rows of Welsh3000 as either YES or
NO. In the report footer I wish to total up all of the "YES". I have
tried SUM and COUNT and DSUM and DCOUNT but I am getting nowhere.

Any help offered will be most appreciated.
Click to expand...

Is it a Yes/No field or a Text field containing "Yes" and "No" strings?

The Yes/No DataType store true as negative one and false as zero so the
following will give you the count of Yes records...

=Abs(Sum([FieldName]))

If you are using a Text field then...

=Sum(IIf([FieldName]="Yes",1,0))
Click to expand...
 
Back
Top