By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,374 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

How to count percentage on report?

yosiro
P: 34
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?
Sep 21 '12 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,342
Use a DCount() to find out how many have over 70 and then divide it by a DCount() of all rows.
Sep 21 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.