计数或总计

本文介绍了计数或总计的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我创建了一个查询，用于提取学生已经学过的课程。有没有办法在报告中添加一个计数来显示学生已经上课的总数？ 该报告目前显示： （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]