need percent based on DCount

  • Thread starter Thread starter CBeavers
  • Start date Start date
C

CBeavers

I'm using this formula in a report footer to obtain the count of scores
greater than 3.
=DCount("[RhymeBOYK]","qryTPRIKinderBOYCurrentYear","[RhymeBOYK]>3")

I then need to get a percentage of this dcount to the total of Count([StuID]).
 
You should be able to use an expression in a control in the report
footer like the following.

=Count(IIF(RhymeBOYK>3,1,Null))/Count(STUID)

That assumes that RHYMEBOYK is a field in the report's record source and
that there is only one record per student in the report.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thank you! That worked!

John Spencer said:
You should be able to use an expression in a control in the report
footer like the following.

=Count(IIF(RhymeBOYK>3,1,Null))/Count(STUID)

That assumes that RHYMEBOYK is a field in the report's record source and
that there is only one record per student in the report.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I'm using this formula in a report footer to obtain the count of scores
greater than 3.
=DCount("[RhymeBOYK]","qryTPRIKinderBOYCurrentYear","[RhymeBOYK]>3")

I then need to get a percentage of this dcount to the total of Count([StuID]).
Click to expand...
Click to expand...
 
Back
Top