Re: How do I count individual records in the Detailed section of a

By sub report do you mean detailed summary? I need to summarize a class’
attributes. By class I mean Class/Section for instance Acc220 002. By
attributes I mean Class average GPA, class minimum GPA, class maximum GPA,
the standard deviation within the class, number of students in the class and
the number of As, Bs, Cs, Ds and Fs. These are represented by numbers: 4, 3,
2, 1 and 0 respectively.

I am able to summarize most of the attributes I am looking for in the Detail
footer by the following: =AVG(GPA), = Min(GPA), =Max(GPA), = StDev(GPA) and
=Count(GPA). This portion works nicely. But how do I breakdown the count to
a count of 4, 3, 2, 1 and 0s?

I can list each GPA for the Class/Section in the Detail section of the
report. However this is not what I want. I do not want a list but rather a
summary count. I’m not sure but I think the answer in VBA code. I just
don’t know how to write it. Something along the lines of count the
particular Class/Section GPA records that = 4 and then count the GPA records
that = 3 and so forth. Thanks for your help and patience. It is
appreciated.

"Duane Hookom" wrote:

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)







.

Relevant Pages