Counting entries?

[marystewart78]

Hi folks,

Working in a report - trying to get it to count entries in a field depending on input - like the countif function in excel ie count entries if they read "Attended" and so on - how do I do this???

Many Thanks,

Mary

 

[boblarson]

In the group or report footer, depending on where you want the counts, you can put this in the textbox's controlsource:

=Count(IIf([YourFieldNameHere]="Attended",1,0))

And, this should yield the same results:

=Sum(IIf([YourFieldNameHere]="Attended",1,0))