计数或总计 [英] counting or total

问题描述

我创建了一个查询，用于提取学生已经学过的课程。有没有办法在报告中添加一个计数来显示学生已经上课的总数？


该报告目前显示：

（Richard class1，class2，class3）


我希望报告显示：

（Richard class1，class2，class3 - Total classes 3）


和往常一样，你的帮助总是很受欢迎。

I''ve created a query which pulls the classes for which a student has taken. Is there a way to add a count to the report to show the total of classes a student has taken?

The report is currently showing:
(Richard class1, class2, class3)

I would like the report to show this:
(Richard class1, class2, class3 - Total classes 3)

As always, your help is always appreciated.

推荐答案

我''我创建了一个查询，用于提取学生已经学过的课程。有没有办法在报告中添加一个计数来显示学生已经上课的总数？


该报告目前显示：

（Richard class1，class2，class3）


我希望报告显示：

（Richard class1，class2，class3 - Total classes 3）


一如既往，我们一直非常感谢您的帮助。

I''ve created a query which pulls the classes for which a student has taken. Is there a way to add a count to the report to show the total of classes a student has taken?

The report is currently showing:
(Richard class1, class2, class3)

I would like the report to show this:
(Richard class1, class2, class3 - Total classes 3)

As always, your help is always appreciated.

您需要为查询发布SQL。这看起来像一个交叉表查询，但我不能说。一旦你发布了完整的sql，我们可以让你更好地了解如何计算。

You will need to post the SQL for your query. This looks like a crosstab query but I can''t really tell. Once you post the full sql we can give you a better idea how to get the count.

你走了。


SELECT EXETER_SSS_STUDENT_SUMMARY_V.FULL_NAME ，EXETER_SSS_STUDENT_SUMMARY_V.SSN，EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM，EXETER_SSS_SECTIONS.COURSE_NAME，EXETER_SSS_SECTIONS.NAME，EXETER_SSS_STUDENT_GRADES.ATTRIBUTE01

FROM（（（（EXETER_SSS_STUDENT_ENROLLMENTS INNER JOIN EXETER_SSS_STUDENT_GRADES ON EXETER_SSS_STUDENT_ENROLLMENTS.ENROLLMENT_ID = EXETER_SSS_STUDENT_GRADES.ENROLLMENT_ID）INNER JOIN（EXETER_SSS_STUDENT_INSTANCE INNER JOIN EXETER_SSS_STUDENT_SUMMARY_V ON EXETER_SSS_STUDENT_INSTANCE.STUDENT_INSTANCE_ID = EXETER_SSS_STUDENT_SUMMARY_V.STUDENT_INSTANCE_ID）ON = EXETER_SSS_STUDENT_ENROLLMENTS.PERSON_ID EXETER_SSS_STUDENT_INSTANCE.PERSON_ID）INNER JOIN EXETER_SSS_GRADE_WEIGHTS ON EXETER_SSS_STUDENT_GRADES.GRADE_WEIGHTS_ID = EXETER_SSS_GRADE_WEIGHTS.GRADE_WEIGHTS_ID）INNER JOIN EXETER_SSS_SECTIONS ON EXETER_SSS_STUDENT_ENROLLMENTS.SECTIO N_ID = EXETER_SSS_SECTIONS.SECTION_ID）INNER JOIN EXETER_CMN_TERMS EXETER_SSS_STUDENT_ENROLLMENTS.TERM_ID = EXETER_CMN_TERMS.TERM_ID

WHERE（（（EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM）=" JD"）AND（（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4L04" ;或者（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4E06"或者（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4B04"或者（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4L06"）AND（（EXETER_CMN_TERMS.TERM_NAME）=" 2005 FA"或（EXETER_CMN_TERMS.TERM_NAME）=" 2006 SP"））

ORDER BY EXETER_SSS_STUDENT_GRADES .ATTRIBUTE01 DESC;

Here you go.

SELECT EXETER_SSS_STUDENT_SUMMARY_V.FULL_NAME, EXETER_SSS_STUDENT_SUMMARY_V.SSN, EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM, EXETER_SSS_SECTIONS.COURSE_NAME, EXETER_SSS_SECTIONS.NAME, EXETER_SSS_STUDENT_GRADES.ATTRIBUTE01
FROM ((((EXETER_SSS_STUDENT_ENROLLMENTS INNER JOIN EXETER_SSS_STUDENT_GRADES ON EXETER_SSS_STUDENT_ENROLLMENTS.ENROLLMENT_ID = EXETER_SSS_STUDENT_GRADES.ENROLLMENT_ID) INNER JOIN (EXETER_SSS_STUDENT_INSTANCE INNER JOIN EXETER_SSS_STUDENT_SUMMARY_V ON EXETER_SSS_STUDENT_INSTANCE.STUDENT_INSTANCE_ID = EXETER_SSS_STUDENT_SUMMARY_V.STUDENT_INSTANCE_ID) ON EXETER_SSS_STUDENT_ENROLLMENTS.PERSON_ID = EXETER_SSS_STUDENT_INSTANCE.PERSON_ID) INNER JOIN EXETER_SSS_GRADE_WEIGHTS ON EXETER_SSS_STUDENT_GRADES.GRADE_WEIGHTS_ID = EXETER_SSS_GRADE_WEIGHTS.GRADE_WEIGHTS_ID) INNER JOIN EXETER_SSS_SECTIONS ON EXETER_SSS_STUDENT_ENROLLMENTS.SECTION_ID = EXETER_SSS_SECTIONS.SECTION_ID) INNER JOIN EXETER_CMN_TERMS ON EXETER_SSS_STUDENT_ENROLLMENTS.TERM_ID = EXETER_CMN_TERMS.TERM_ID
WHERE (((EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM)="JD") AND ((EXETER_SSS_SECTIONS.COURSE_NAME)="4L04" Or (EXETER_SSS_SECTIONS.COURSE_NAME)="4E06" Or (EXETER_SSS_SECTIONS.COURSE_NAME)="4B04" Or (EXETER_SSS_SECTIONS.COURSE_NAME)="4L06") AND ((EXETER_CMN_TERMS.TERM_NAME)="2005 FA" Or (EXETER_CMN_TERMS.TERM_NAME)="2006 SP"))
ORDER BY EXETER_SSS_STUDENT_GRADES.ATTRIBUTE01 DESC;

我不知道Access是否允许你这样做，但它是我能看到的唯一选项。顺便说一下，用这个查询的名称替换'' ThisQueryName'' 。

SELECT EXETER_SSS_STUDENT_SUMMARY_V.FULL_NAME，EXETER_SSS_STUDENT_SUMMARY_V.SSN， EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM，EXETER_SSS_SECTIONS.COURSE_NAME，EXETER_SSS_SECTIONS.NAME，EXETER_SSS_STUDENT_GRADES.ATTRIBUTE01，
DCount（" [COURSE_NAME]"， ThisQueryName "，[FULL_NAME] ] ="&安培; [FULL_NAME]）AS CourseCount

FROM（（（（EXETER_SSS_STUDENT_ENROLLMENTS INNER JOIN EXETER_SSS_STUDENT_GRADES ON EXETER_SSS_STUDENT_ENROLLMENTS.ENROLLMENT_ID = EXETER_SSS_STUDENT_GRADES.ENROLLMENT_ID）INNER JOIN（EXETER_SSS_STUDENT_INSTANCE INNER JOIN EXETER_SSS_STUDENT_SUMMARY_V ON EXETER_SSS_STUDENT_INSTANCE.STUDENT_INSTANCE_ID = EXETER_SSS_STUDENT_SUMMARY_V.STUDENT_INSTANCE_ID）EXETER_SSS_STUDENT_ENROLLMENTS.PERSON_ID = EXETER_SSS_STUDENT_INSTANCE.PERSON_ID）内部加入EXETER_SSS_GRADE_WEIGHTS EXETER_SSS_STUDENT_GRADES.GRADE_WEIGHTS_ID = EXETER_SSS_GRA DE_WEIGHTS.GRADE_WEIGHTS_ID）INNER JOIN EXETER_SSS_SECTIONS ON EXETER_SSS_STUDENT_ENROLLMENTS.SECTION_ID = EXETER_SSS_SECTIONS.SECTION_ID）INNER JOIN EXETER_CMN_TERMS ON EXETER_SSS_STUDENT_ENROLLMENTS.TERM_ID = EXETER_CMN_TERMS.TERM_ID

，其中（（（EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM）=" JD"）和（（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4L04"或者（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4E06"或者（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4B04"或者（EXETER_SSS_SECTIONS.COURSE_NAME）=" 4L06"）AND（（EXETER_CMN_TERMS.TERM_NAME）=" 2005 FA"或（EXETER_CMN_TERMS.TERM_NAME）=" 2006 SP"））

ORDER BY EXETER_SSS_STUDENT_GRADES .ATTRIBUTE01 DESC; [/ quote]

I don''t know if Access will let you do this but its the only option that I can see. BTW, replace ''ThisQueryName'' with the name of this query.

SELECT EXETER_SSS_STUDENT_SUMMARY_V.FULL_NAME, EXETER_SSS_STUDENT_SUMMARY_V.SSN, EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM, EXETER_SSS_SECTIONS.COURSE_NAME, EXETER_SSS_SECTIONS.NAME, EXETER_SSS_STUDENT_GRADES.ATTRIBUTE01,
DCount("[COURSE_NAME]","ThisQueryName","[FULL_NAME]=" & [FULL_NAME]) AS CourseCount
FROM ((((EXETER_SSS_STUDENT_ENROLLMENTS INNER JOIN EXETER_SSS_STUDENT_GRADES ON EXETER_SSS_STUDENT_ENROLLMENTS.ENROLLMENT_ID = EXETER_SSS_STUDENT_GRADES.ENROLLMENT_ID) INNER JOIN (EXETER_SSS_STUDENT_INSTANCE INNER JOIN EXETER_SSS_STUDENT_SUMMARY_V ON EXETER_SSS_STUDENT_INSTANCE.STUDENT_INSTANCE_ID = EXETER_SSS_STUDENT_SUMMARY_V.STUDENT_INSTANCE_ID) ON EXETER_SSS_STUDENT_ENROLLMENTS.PERSON_ID = EXETER_SSS_STUDENT_INSTANCE.PERSON_ID) INNER JOIN EXETER_SSS_GRADE_WEIGHTS ON EXETER_SSS_STUDENT_GRADES.GRADE_WEIGHTS_ID = EXETER_SSS_GRADE_WEIGHTS.GRADE_WEIGHTS_ID) INNER JOIN EXETER_SSS_SECTIONS ON EXETER_SSS_STUDENT_ENROLLMENTS.SECTION_ID = EXETER_SSS_SECTIONS.SECTION_ID) INNER JOIN EXETER_CMN_TERMS ON EXETER_SSS_STUDENT_ENROLLMENTS.TERM_ID = EXETER_CMN_TERMS.TERM_ID
WHERE (((EXETER_SSS_STUDENT_SUMMARY_V.PROGRAM)="JD") AND ((EXETER_SSS_SECTIONS.COURSE_NAME)="4L04" Or (EXETER_SSS_SECTIONS.COURSE_NAME)="4E06" Or (EXETER_SSS_SECTIONS.COURSE_NAME)="4B04" Or (EXETER_SSS_SECTIONS.COURSE_NAME)="4L06") AND ((EXETER_CMN_TERMS.TERM_NAME)="2005 FA" Or (EXETER_CMN_TERMS.TERM_NAME)="2006 SP"))
ORDER BY EXETER_SSS_STUDENT_GRADES.ATTRIBUTE01 DESC;[/quote]

这篇关于计数或总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！