How to count percentage on report?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yosiro
    New Member
    • Aug 2012
    • 34

    How to count percentage on report?

    In the report i have some value like these:

    Idstudent-------Score
    1-----------------------70
    2-----------------------80
    3-----------------------50
    4-----------------------40
    5----------------------100

    So i want to add an information about the percentage of how many student who have score above 70 at the footer report.

    The information above tell us that there are 3 persons who have score above 70 (the result must be (3/5*100%), so how to calculate them in access report?
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Use a DCount() to find out how many have over 70 and then divide it by a DCount() of all rows.

    Comment

    Working...