Re: How do I count individual records in the Detailed section of a
- From: ran <ran@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 31 Aug 2006 21:03:02 -0700
Sorry for the delay in getting back, network connectivity issues.
I’m not sure I have the expertise to do what you are recommending. I
created a query that counts the number of 4s in a particular class/section.
How do I associate this query with the Record Source? Or do I? When I click
on Text Box in Design View for Control Source I choose the field, in this
case GPA. Then paste my query into the Expression Builder. However I feel
that this is an improper method in that 1, the results are inaccurate.
Everything is 4. And 2, when I go back to check the query in Expression
Builder after previewing the form, all I see is the field name (GPA). Here
is the query I paste.
SELECT DISTINCTROW [GPAsections2005].[Class], [GPAsections2005].[Section],
Count(*) AS [Count Of GPAsections2005]
FROM GPAsections2005
WHERE ((([GPAsections2005].[GPA])=4))
GROUP BY [GPAsections2005].[Class], [GPAsections2005].[Section];
"Duane Hookom" wrote:
You need to create a totals query that counts GPA grouped by GPA,.
Class/Section and whatever other field that your report might be Grouped by.
This should result in a record set of your number of students with As, Bs,
....or 4s, 3s, 2s,...
Use this totals query as the Record Source of a report. Then add this report
to the Class/Section footer or header of your report and set the Link
Master/Child properties to Class/Section and whatever other field that your
report might be Grouped by.
--
Duane Hookom
MS Access MVP
"ran" <ran@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CEC6101F-8D97-4CF7-A87C-080A572C699D@xxxxxxxxxxxxxxxx
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)
- Follow-Ups:
- Re: How do I count individual records in the Detailed section of a
- From: Duane Hookom
- Re: How do I count individual records in the Detailed section of a
- Prev by Date: Re: Loop in Report Detail Section
- Next by Date: Re: How do I count individual records in the Detailed section of a
- Previous by thread: Re: How to update ListBox.RowSource property when printing
- Next by thread: Re: How do I count individual records in the Detailed section of a
- Index(es):
Relevant Pages
|
