countif in Access Reports

[P T Pi]

I need to countif, where [gradeCompleted] is text with values of 8,9,10,11 or
12
=IIf([qClass Profile R2]![gradeCompleted]=8,1,0)
This is an inherited db that has 2 full capacity tables and will not accept
a datatype change

 

[Allen Browne]

Try:
=IIf([qClass Profile R2]![gradeCompleted] IN ("8", "9", "10", "11",
"12"), 1, 0)

I am uncertain whether the IN operator will work in this context, but give
it a shot. If that doesn't work, you could try putting the expression into a
Field in the query, and you would then be able to sum that field in your
report.

 

[P T Pi]

Thank you very much Allen. It actually worked well.

Try:
=IIf([qClass Profile R2]![gradeCompleted] IN ("8", "9", "10", "11",
"12"), 1, 0)

I am uncertain whether the IN operator will work in this context, but give
it a shot. If that doesn't work, you could try putting the expression into a
Field in the query, and you would then be able to sum that field in your
report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I need to countif, where [gradeCompleted] is text with values of 8,9,10,11
or
12
=IIf([qClass Profile R2]![gradeCompleted]=8,1,0)
This is an inherited db that has 2 full capacity tables and will not
accept
a datatype change