need percent based on DCount

[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]).

 

[Evi]

A percentage is
(Your count of the part/Your count of the whole)*100
Evi

 

[John Spencer]

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
'====================================================

 

[CBeavers]

Thank you! That worked!

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]).