report to return # of times the word "incorrect" is in a field

[ltvrdy]

Hello all -

In my database, i have a report where i need to know how many times an associate provided an incorrect answer to a question. I can't get the code written correctly. The "incorrect" is a choice from a combo box of choices (incorrect, correct, uncertain/incomplete). These are housed in a table that i created a query to pull data from. The report is to filter that data to obtain how many times each type appeared during the specified timeframe. I'm fairly new to access, so i'm not quite sure where to start writing the code. This was an idea of what i had so far:

=Sum(IIf([Call Rating]=[Incorrect],1,0))

or

=IIF([Call Rating]=”Incorrect”,1,0))

or

-Count([Call Rating]=[Incorrect],1,0)

 

[pbaldy]

Mixing your efforts:

=Sum(IIf([Call Rating]="Incorrect",1,0))

 

[ltvrdy]

Thank you! i knew it was something logical, but needed another set of eyes. Here's what ended up working:

=Sum(IIf([Call Rating]="Incorrect",1,0))

The other suggestion gave me this error: #error

Thanks again!

 

[pbaldy]

Happy to help!