Re: How do I count individual records in the Detailed section of a
- From: "Duane Hookom" <DuaneAtNoSpanHookomDotNet>
- Date: Mon, 28 Aug 2006 08:24:54 -0500
If I understand correctly, you need to create a subreport based on a totals
query that groups by GPA and others such as Class etc. Count the number of
GPA in the totals query. Add the subreport to a footer in your main report
and join the appropriate fields.
--
Duane Hookom
MS Access MVP
"ran" <ran@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5DACB953-EE91-4925-B3D5-A397193AACCA@xxxxxxxxxxxxxxxx
My table has these fields: Dept (text), Year (Date), Term (text), Session
(text), GPA (byte, can be 0 to 4), Class (text), Section (text), Class
(text), Title (text).
Please let me explain in more detail. Each Department has a list of
classes
that they offer at different sessions (Fall, Spring, Summer) during the
year.
These sections have students that are given grades. Here the field is
named
GPA, since it is the grade point average for the student for that
class/section. For instance Acc220 002. There may be a Acc220 002 in the
Fall, Spring and Summer of each year.
Each class/section has X amount of students. That I can count using
Count(*).
My dilemma is how to count the number of 0, 1, 2, 3, and 4s (the grades:
0=F, 1=D, 2=C, 3=B, 4=A) that may be distributed to the students in the
GPA
column. For instance Acc220 002 may have 12 records (students). Of these
12
records how many are 0, 1, 2, 3, and 4s? In other words how many As Bs Cs
and so forth were given in a particular class section.
"Duane Hookom" wrote:
Do you mind sharing your table structure? Specifically, I'm wondering if
classes are fields or is your table structure normalized?
--
Duane Hookom
MS Access MVP
"ran" <ran@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF6FBB66-4932-411B-B43D-93A2A892F73F@xxxxxxxxxxxxxxxx
Hi: I'm working on an Access report. I have a table that has records
that
list:
Year, Term, Class, Department, Section and each grade given in each
class
section. My report should summarize each class section. This summary
should
have: Number of students in the class. Here I use Count(*) which gives
me
the correct number of students in the class.
But I'm also trying to get the number of As, Bs, Cs Ds & Fs in each
individual class section. These are coded as 4,3,2,1, & 0
respectively.
I
am able to get a class section average, the minimum grade and the
maximum
grade along with a standard deviation for each class section. However
I
cannot seem to get a count of how many 4(As) or 3(Bs) and so forth for
each
class section.. Thank you (I'm using Access 2000)
.
- Follow-Ups:
- References:
- Re: How do I count individual records in the Detailed section of a Rep
- From: Duane Hookom
- Re: How do I count individual records in the Detailed section of a Rep
- Prev by Date: Re: Non-descriptive error message
- Next by Date: Re: Calculations on report...
- Previous by thread: Re: How do I count individual records in the Detailed section of a Rep
- Next by thread: Re: How do I count individual records in the Detailed section of a
- Index(es):
Relevant Pages
|
