DCount Function (1 Viewer)

[Petersen]

I’m trying to sum the number of “Yes’s” in a Yes/No field on a report.

1) In the footer of the report I created an unbound text field
2) I then went to Properties, Control Source, and typed in the DCount function as follows: =DCount([FieldName],”-1”) … no luck …

I’m confused. Any help will be appreciated.

 

[Fornatian]

Try this or similar syntax:
To count yes's
=sum(iif(Me![Myfieldname]="Yes",1,0))
To count no's
=sum(iif(Me![Myfieldname]="No",1,0))
This should work.

Ian