If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
countif in Access Reports
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 |
#2
|
|||
|
|||
countif in Access Reports
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "P T Pi" P T wrote in message ... 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 |
#3
|
|||
|
|||
countif in Access Reports
Thank you very much Allen. It actually worked well.
"Allen Browne" wrote: 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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "P T Pi" P T wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|