Count fields with a text value

[primagic]

I have a table that includes 5 text fields. These text fields have the value either "Correct" or "Incorrect" or are blank

How can I count the number of "Corrects" in a record and also display 0 if no "Corrects".

I have tried DCount and DSum but its not working.

 

[PWise]

Sum(iif(Textfield="Correct",1,0))

 

[primagic]

Hi PWise,

Thank you for your reply. Your code works however I wanted to sum "Corrects" like:


Name Text1 Text2 Text3 Text4 Text5 Sum

Smith Correct Correct Incorrect Correct Incorrect = 3
Jones Incorect Incorrect Incorrect Correct Incorrect = 1
Hunter Incorrect Incorrect Incorrect Incorrect Incorrect = 0

 

[PWise]

Select iif(Text1="Correct",1,0)+ iif(Text2="Correct",1,0)+ 
iif(Text3="Correct",1,0)+ iif(Text4="Correct",1,0)+ iif(Text5="Correct",1,0)
From Tablename

 

[PWise]

Select [name] ,iif(Text1="Correct",1,0)+ iif(Text2="Correct",1,0)+ 
iif(Text3="Correct",1,0)+ iif(Text4="Correct",1,0)+ iif(Text5="Correct",1,0)
From Tablename 



[code]