 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006count expression
Is there a way to use the Count expression in a report so that I may be able to obtain the total number of a particular input in a column? For example, if I have a column which contains student marks, in the Text Box control source I could enter an expression like: =Count([Student Marks]) and this would output the total number of student marks I have in the column. But if I wanted to obtain the total number of, for example, students that obtained an "A", how would I enter the expression in the control source to output this request? Thanks. Try =Sum(IIf([Student Marks] = "A",1,0))  Signature\\// Live Long and Prosper \\// BS"D > Is there a way to use the Count expression in a report so that I may be able > to obtain the total number of a particular input in a column? For example, [quoted text clipped - 4 lines] > an "A", how would I enter the expression in the control source to output this > request? Thanks. Use Abs and Sum with a boolean expression. =Abs(Sum([Student Marks]="A")) > Is there a way to use the Count expression in a report so that I may be able > to obtain the total number of a particular input in a column? For example, [quoted text clipped - 4 lines] > an "A", how would I enter the expression in the control source to output this > request? Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.