In Report Count "YES"

[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

 

[Rick Brandt]

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.

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))

 

[Ady]

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

Was successful!

Many thanks!

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.

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))