CODEWITHSUNDEEP
ms-access-2003
Desert Spider
Desert Spider

Reputation: 778

ms-access 2003 countif in a report

I have a report that displays all office employees. I am trying to give a summary of employee by type in the foother of the report and I receive an #Error as a result.

Report Detail
Name    DOH    UserID    Position

Page Footer
Text Box with "=Count(IIf([Position] Like "CS",0))"
I have also tried "=Count(IIf([Position]="CS",0))"

Both Return #Error

Upvotes: 0

Views: 599

Answers (1)

Desert Spider
Desert Spider

Reputation: 778

Through Trial and error I found the following to work

=Count(IIf([Position]="CS",1,0))

Upvotes: 1

Related Questions