473,383 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

How to count percentage on report?

yosiro
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
1 1704
Rabbit
12,516 Expert Mod 8TB
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

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

Similar topics

0
by: raj | last post by:
hi, i am getting JavaScript error while adding the <Toolbar>True</Toolbar> in sql reporting services i have defined the device info as string devInfo ="<DeviceInfo><Zoom>" +...
3
by: =?Utf-8?B?ZHJhYmVl?= | last post by:
Greetings: Please This is the first time i'm using crystal report i'm passing Parameters like code belowe but what i'm getting alwayes just the last record pleeeeeeeeeeeeeeeease any help ...
1
by: N06149 | last post by:
I have a report based on a query. I list an Org_Type then Org_Name then the Projects associated with it. Sample of report below: Community Type...
7
by: AccessHunter | last post by:
Hi, Please help with this problem. I have a report that displays a list of Case/Judge Records. using the following fields, Case Nbr, Case Seq Nbr, Judge Name, Attorney name 723187, 1...
0
denny1824
by: denny1824 | last post by:
I have a crystal report that someone else wrote and already has a Formula Field if Criteria then (Count ({FirstField},{SecondField}) / Count ({FirstField})) When the Criteria is true, this...
0
by: Kelii | last post by:
Evenlater, Yeah, I don't open the report in preview mode when I setup my recordsource, filters, or sorts. Before I give my solution, I would say that your code will be simpler if you drop the...
14
by: zufie | last post by:
I have to create a QA report regarding callers calling into a phone hotline. The report consists of many checkboxes such as: Did the IBCCP agency contact you? Yes/NO How many days passed...
1
by: KMEscherich | last post by:
Using Access 2003 Hi there, am wondering if someone can please help me with retrieving DISTINCT COUNT of a type field. I can get a total, which in this example would = 9, but I also need to know...
7
AccessIdiot
by: AccessIdiot | last post by:
This seems like it should be really easy and I think I'm just missing something really dumb. I have a form that filters a report. At the top of the report I have a bunch of unbound text boxes that...
0
by: beulajo | last post by:
Hi, I m using Reportviewer control to show my statistical reports I need to show the report both in the form of table and chart Scenario : I have set of clients say (100 clients) in that I...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.