Count IF

[mr moe]

Can I do a countif in the report. I want to show all record in the report but only count certain things. For example I have a cloumn that has more than one value, I want to show all records, but in the bottom of the report I want to count only one value.

 

[boblarson]

Put a text box in the appropriate footer to capture the totals for the right groupings and then use:

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

 

[mr moe]

Thank you so much, I'm sorry for the delay but I used it one more time LOL.

Put a text box in the appropriate footer to capture the totals for the right groupings and then use:

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